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 |
+---------------------+