Syntax
CURRENT_DATE( )
Description
The CURRENT_DATE SQL scalar function returns a date 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_TIME or CURRENT_TMSTP scalar functions within a single statement, all values are based on a single clock reading.
The data type of the result is a date.
Example
Return the current date based on the time-of-day clock.
CURRENT_DATE( )
List of SQL scalar functions by topic