Add default value of datetime field in SQL Server to a timestamp

Posted By: Anonymous

I’ve got a table that collects forms submitted from our website, but for some reason, when they created the table, they didn’t put a timestamp in the table. I want it to enter the exact date and time that the record was entered.

I know it’s in there somewhere, but I can’t seem to find how to set the default value (like in Access, you use getNow() or Now()) but I don’t know where to put it.

Solution

For modifying an existing column in an existing table:

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

Answered By: Anonymous

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.