All Products
Search
Document Center

CURRENT_DATE

Last Updated: Jun 18, 2021

The CURRENT_DATE function returns the current date in the session time zone.

Syntax

CURRENT_DATE

Parameters

No parameters are involved.

Return type

The return type is DATE.

Examples

In the following examples, the CURRENT_DATE function returns the current date in different session time zones.

Set the current time zone to the UTC-5 time zone:

ALTER SESSION SET TIME_ZONE = '-05:00';

Execute the following statement to call the function:

SELECT CURRENT_DATE FROM DUAL;

The following result is returned:

+---------------------+
| CURRENT_DATE        |
+---------------------+
| 2020-03-08 01:40:11 |
+---------------------+

Change the current time zone to the UTC+8 time zone:

ALTER SESSION SET TIME_ZONE = '+08:00';

Execute the following statement to call the function:

SELECT CURRENT_DATE FROM DUAL;

The following result is returned:

+---------------------+
| CURRENT_DATE        |
+---------------------+
| 2020-03-08 14:40:11 |
+---------------------+