Oracle CURRENT_DATE function

Last update on September 02 2024 06:49:53 (UTC/GMT +8 hours)

How to get the current date in the session time zone in Oracle?

CURRENT_DATE returns the current date in the session time zone, in a value in the Gregorian calendar of datatype DATE.

Time Zone Awareness: Display the current date and time according to the session's time zone.

Date Formatting: Use with NLS_DATE_FORMAT to display the current date in various formats.

Session Customization: Adapt the current date output by altering the session time zone.

Date Tracking: Keep track of events or transactions based on the current session's date.

Syntax:

CURRENT_DATE

Parameters:
No parameters or arguments

Applies to:
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i

Pictorial Presentation

Example: Oracle CURRENT_DATE() function

The following statement shows the current date in 'DD-MON-YYYY HH24:MI:SS' format :

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
Session altered.

Let display the current date and session timezone.:

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';
Session altered.
SQL> SELECT CURRENT_DATE, SESSIONTIMEZONE FROM DUAL;

Sample Output:

CURRENT_DATE            SESSIONTIMEZONE
--------------------    -----------------------
01-MAY-2015 11:19:41    +05:30

Let change the session timezone using ALTER SESSION command :

SQL> ALTER SESSION SET TIME_ZONE = '-2:0';
Session altered.

Now check the current date and session timezone :

SQL> SELECT CURRENT_DATE, SESSIONTIMEZONE FROM DUAL;

Sample Output:

CURRENT_DATE            SESSIONTIMEZONE
--------------------    -----------------------
01-MAY-2015 04:26:26    -02:00

Previous: ADD_MONTHS
Next: CURRENT_TIMESTAMP