How Do I Do an Insert with Datetime Now Inside of Sql Server Mgmt Studio
I Have a Website That Does Inserts into This Table Below. I Need to Do Some Manual Inserts but I Wasn't Sure How Do Pass in the Equivalent of Datetime. Now in...
I have a website that does inserts into this table below. I need to do some manual inserts but I wasn't sure how do pass in the equivalent of DateTime.Now in C#.
I am running this below from the query editor in SQL server mgmt studio. Is there any way to pass in the current date time in this query below.
INSERT INTO [Business]
([IsDeleted]
,[FirstName]
,[LastName]
,[LastUpdated]
,[LastUpdatedBy])
VALUES
(0, 'Joe', 'Thomas',
,<LastUpdated, datetime,>
,<LastUpdatedBy, nvarchar(50),>)
2 Answers
Use CURRENT_TIMESTAMP (or GETDATE() on archaic versions of SQL Server).
Just use GETDATE() or GETUTCDATE() (if you want to get the "universal" UTC time, instead of your local server's time-zone related time).
INSERT INTO [Business]
([IsDeleted]
,[FirstName]
,[LastName]
,[LastUpdated]
,[LastUpdatedBy])
VALUES
(0, 'Joe', 'Thomas',
GETDATE(), <LastUpdatedBy, nvarchar(50),>)
Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.
