- Categories:
Context Functions (General)
CURRENT_DATE¶
Returns the current date of the system.
Syntax¶
CURRENT_DATE()
CURRENT_DATE
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();Output:
+----------------+----------------+--------------------------------+ | CURRENT_DATE() | CURRENT_TIME() | CURRENT_TIMESTAMP() | |----------------+----------------+--------------------------------| | 2018-09-28 | 17:18:02 | 2018-09-28 17:18:02.826 -0700 | +----------------+----------------+--------------------------------+