Syntax
CURRENT_TMSTP( )
Description
The CURRENT_TMSTP SQL scalar function returns a timestamp based on a reading of the time-of-day clock when the SQL statement is executed at the current server. If this function is used more than once within a single SQL statement, or used with the CURRENT_DATE or CURRENT_TIME scalar functions within a single statement, all values are based on a single clock reading.
The data type of the result is a timestamp.
Example
Return the current timestamp based on the time-of-day clock.
CURRENT_TMSTP( )
List of SQL scalar functions by topic