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