Categories:: Context Functions (General)

CURRENT_DATE¶

Returns the current date of the system.

Syntax¶

CURRENT_DATE()

CURRENT_DATE

Copy

Arguments¶

None.

Returns¶

The function returns a value of type DATE.

Usage notes¶

To comply with ANSI standards, this function can be called without parentheses.

Examples¶

Show the current date, time, and timestamp:

SELECT CURRENT_DATE(), CURRENT_TIME(), CURRENT_TIMESTAMP();

Copy

+----------------+----------------+-------------------------------+
| CURRENT_DATE() | CURRENT_TIME() | CURRENT_TIMESTAMP()           |
|----------------+----------------+-------------------------------|
| 2024-04-18     | 07:47:37       | 2024-04-18 07:47:37.084 -0700 |
+----------------+----------------+-------------------------------+