Categories:

Context Functions (General)

CURRENT_DATE¶

Returns the current date of the system.

Syntax¶

CURRENT_DATE()

CURRENT_DATE
Copy

Usage Notes¶

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

Arguments¶

None.

Examples¶

Show the current date, time, and timestamp:

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

Output:

+----------------+----------------+--------------------------------+
| CURRENT_DATE() | CURRENT_TIME() | CURRENT_TIMESTAMP()            |
|----------------+----------------+--------------------------------|
|     2018-09-28 |       17:18:02 | 2018-09-28 17:18:02.826 -0700  |
+----------------+----------------+--------------------------------+
Copy