Add default value of datetime field in SQL Server to a timestamp
For modifying an existing column in an existing table:
ALTER TABLE YourTable ADD CONSTRAINT DF_YourTable DEFAULT GETDATE() FOR YourColumn
This can also be done through the SSMS GUI.
- Put your table in design view (Right click on table in object explorer->Design)
- Add a column to the table (or click on the column you want to update if it already exists)
- In Column Properties, enter
(getdate())in Default Value or Binding field as pictured below
In that table in SQL Server, specify the default value of that column to be CURRENT_TIMESTAMP.The datatype of that column may be datetime or datetime2.
e.g.
Create Table Student( Name varchar(50), DateOfAddmission datetime default CURRENT_TIMESTAMP);