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