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