CURDATE,CURRENT_DATE

Description

Retrieves the current date and returns it as a DATE type.

Alias

• curdate
• current_date

Syntax

CURDATE()

Return Value

The current date.

Examples

SELECT CURDATE();

+------------+
| CURDATE()  |
+------------+
| 2019-12-20 |
+------------+

SELECT CURDATE() + 0;

+---------------+
| CURDATE() + 0 |
+---------------+
|      20191220 |
+---------------+