Oracle PL/SQL Tutorial/Date Timestamp Functions/CURRENT DATE

Getting the Current Date in the Session Time Zone

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.

   <source lang="sql">

SQL> SELECT CURRENT_DATE FROM dual; CURRENT_D

---

31-MAY-07 SQL></source>