CURRENT_DATE

Purpose

CURRENT_DATE returns the current date in the time zone of the current session.

Syntax

CURRENT_DATE

Return type

The return type is DATE.

Examples

The following example uses CURRENT_DATE to return the current date in the current time zone.

obclient> SELECT CURRENT_DATE FROM DUAL;
+--------------+
| CURRENT_DATE |
+--------------+
| 17-NOV-21    |
+--------------+
1 row in set