Adding current date time in SQL Table using SSMS Edit Mode

Question

How can I add the current date time to a SQL table in edit mode?

That is, in MS SQL, when you do right click on a table and click on Edit Top 200 Rows. I would like to fill current date time in the cell.

GETDATE() or CURRENT_TIMESTAMP does not work.

Answer 1

Here's something fairly quick and easy.

In a new query window execute the query, SELECT GETDATE().

Select the result in the result pane and ctrl-c to copy it to the clipboard.

Then go back to your Edit window, and paste into the datetime cell(s).

Answer 2

You can't manually call GETDATE() in edit mode. Instead, add GETDATE() as the default value for the column in design mode, and refrain from adding a value to the column in edit mode. Then SQL Server will add the current date-time as the value.