Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. 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.

SQL> SELECT CURRENT_DATE FROM dual;
CURRENT_D
---------
31-MAY-07
SQL>