- Categories:
Context Functions (General)
CURRENT_DATE¶
Returns the current date of the system.
Syntax¶
CURRENT_DATE()
CURRENT_DATE
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();
+----------------+----------------+-------------------------------+
| CURRENT_DATE() | CURRENT_TIME() | CURRENT_TIMESTAMP() |
|----------------+----------------+-------------------------------|
| 2024-04-18 | 07:47:37 | 2024-04-18 07:47:37.084 -0700 |
+----------------+----------------+-------------------------------+