How do I paste with DATETIME now inside SQL Server mgmt studio

Question

I have a website that inserts into this table below. I need to do some manual insertions, but I was not sure how to get through the equivalent of DateTime.Now in C #.

I run this below from the query editor in sql server mgmt studio. In any case, at this point in time in this request will pass.

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

Answer 1

Use CURRENT_TIMESTAMP (or GETDATE () in archaic versions of SQL Server).

Answer 2

Just use GETDATE() or GETUTCDATE() (if you want to get the "universal" UTC time, not the time associated with the time zone of your local server).

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