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