This function is the ANSI SQL equivalent to GETDATE. See Date and Time Data Types and Functions for an overview of all the [!INCLUDEtsql] date and time data types and functions. These examples use the ...

CURRENT_TIMESTAMP returns the current date and time in the session time zone, in a value of data type TIMESTAMP WITH TIME ZONE. The time zone offset reflects the current local time of the SQL session.