You have a ‘datetime’ field in an SQL server database table and need it to automatically use the current date and time when the row is created.
- Open the database using SQL Management Studio
- Right-clicking on the table and selecting ‘Design’
- Selected the existing ‘datetime’ field (or creating one)
- In the ‘Column Properties’ below, under ‘Default Value or Binding’ enter getdate()
- Save the changes to the table