CURRENT_DATE

CURRENT_DATE returns the current date in the local time zone in the database session. The SYSDATE function gets the date in the database time zone. CURRENT_DATE function gets the date in your session time zone.


SQL> SELECT CURRENT_DATE
  2  FROM dual;

CURRENT_D
---------
08-JUL-12

SQL>

Home »
Oracle »
Time Zone Functions »