SYSDATETIME
CURRENT_TIMESTAMP
DATEADD
Returns the current date and time (equivalent to GETDATE()).
SELECT CURRENT_TIMESTAMP AS now;