Add default timestamp to db column

Use Default Constraint>

ALTER TABLE YourTable ADD CONSTRAINT DF_YourTable DEFAULT GETDATE() FOR YourColumn

e.g.

ALTER TABLE confirm_data_update ADD CONSTRAINT DF_CREATED DEFAULT GETDATE() FOR created