Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
CURRENT_DATE And CURDATE
Returns the current date.
Syntax
CURRENT_DATE()
CURDATE()
Return Type
Date object.
Remarks
CURDATE() and CURRENT_DATE() functions are synonyms to each other. Both the functions return the current date in either YYY-MM-DD (string) or YYYYMMDD (numeric) format.
Examples
The following functions return the current date in string format.
SELECT CURRENT_DATE(), CURDATE();
****
+-------------------------------------------------------------+
| CURRENT_DATE() | CURDATE() |
+-------------------------------------------------------------+
| 2019-03-22 | 2019-03-22 |
+-------------------------------------------------------------+
Related Topics
