This Oracle tutorial explains how to use the Oracle/PLSQL CURRENT_DATE function.
CURRENT_DATE returns the current date in the local time zone in the database session.
The session can be set by the ALTER SESSION command.
SYSDATE function gets the date in the database time zone.
CURRENT_DATE function gets the date in your session time zone.
The syntax for the Oracle/PLSQL CURRENT_DATE function is:
There are no parameters for the CURRENT_DATE function.
SQL> SELECT CURRENT_DATE 2 FROM dual; CURRENT_D --------- 08-JUL-12 SQL>
If the following ALTER SESSION command was issued:
ALTER SESSION SET TIME_ZONE = '-7:0';
And then the following SQL statement was executed:
select CURRENT_DATE from dual;
The code above generates the following result.
9/10/2014 12:24:24 PM