Outdated Version
You are viewing an older version of this section. View current production version.
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
