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 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),>)

sql-server
datetime

495286 次浏览

小开

最佳答案

对 SQLServer 的旧版本使用 CURRENT _ TIMESTAMP(或 GETDATE ())。

小开

只需使用 GETDATE()或 GETUTCDATE()(如果您希望获得“通用”UTC 时间，而不是本地服务器的时区相关时间)。

INSERT INTO [Business]
([IsDeleted]
,[FirstName]
,[LastName]
,[LastUpdated]
,[LastUpdatedBy])
VALUES
(0, 'Joe', 'Thomas',
GETDATE(),  <LastUpdatedBy, nvarchar(50),>)