The CURRENT_DATE function returns the current date in the session time zone, as a value in the Gregorian calendar.
Return Values
DATETIME
Syntax
CURENT_DATE
Examples
Example 7-58 Retrieving the Current Date
Assume you want to retrieve the date when the date is February 13, 2007.
SHOW NLS_DATE_FORMAT DD-MON-RR SHOW CURRENT_DATE 13-FEB-07
