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

This can also be done through the SSMS GUI.

1. Put your table in design view (Right click on table in object explorer->*Design*)
2. Add a column to the table (or click on the column you want to update if it already exists)
3. In Column Properties, enter `(getdate())` in *Default Value or
Binding* field as pictured below

[![Image of table in design view][1]][1]


[1]:

This works for me...

ALTER TABLE [accounts]
ADD [user_registered] DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ;

In that table in SQL Server, specify the default value of that column to be [`CURRENT_TIMESTAMP`](

[To see links please register here]

).
The datatype of that column may be `datetime` or `datetime2`.

e.g.

Create Table Student
(
Name varchar(50),
DateOfAddmission datetime default CURRENT_TIMESTAMP
);