Oracle Date/Time Function - Oracle/PLSQL CURRENT_DATE Function






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.

The SYSDATE function gets the date in the database time zone. CURRENT_DATE function gets the date in your session time zone.

Syntax

The syntax for the Oracle/PLSQL CURRENT_DATE function is:

CURRENT_DATE

There are no parameters for the CURRENT_DATE function.

Example


SQL> SELECT CURRENT_DATE
  2  FROM dual;

CURRENT_D
---------
08-JUL-12

SQL>




Combined with Alter Session

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