better way is to define a default and bind to the column as follows.

It is better to avoid triggers to improve the performance.

create default today as getdate()

sp_bindefault today ,'