Oracle PL/SQL/Date Timezone/CURRENT DATE

CURRENT_DATE: Get the date in your session time zone

SQL>
SQL> --Get the date in your session time zone using the CURRENT_DATE() function
SQL>
SQL> SELECT CURRENT_DATE FROM dual;
CURRENT_DAT
-----------
2006-SEP-16
SQL>
SQL>