CURRENT_DATE And CURDATE

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

• CURRENT_TIMESTAMP

• CURRENT_TIME And CURTIME

• Data Types

• DATE