Getting the Current Date in the Session Time Zone : CURRENT_DATE « Date Timestamp Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Date Timestamp Functions
3. CURRENT_DATE

SYSDATE() function gets the date for the operating system where the database resides.

You can get the date in your session time zone using the CURRENT_DATE() function.

SQL> SELECT CURRENT_DATE FROM dual;

CURRENT_D
---------
31-MAY-07

SQL>