MSSQLDate/Time FunctionsCURRENT_TIMESTAMP
SYSDATETIME

CURRENT_TIMESTAMPDate/Time Functions

DATEADD

Returns the current date and time (equivalent to GETDATE()).

Syntax

CURRENT_TIMESTAMP

Example

SELECT CURRENT_TIMESTAMP AS now;