Returns the current date.
TODAY( * )
Use this syntax in place of the historical CURRENT DATE function.
SQL/2003 Vendor extension.
The following statements return the current day according to the system clock.
SELECT TODAY( * ) ; SELECT CURRENT DATE