curdate,current_date
Description
Syntax:
DATE CURDATE()
This function fetches the current date and returns it in the DATE type.
Example
mysql> SELECT CURDATE();
+------------+
| CURDATE() |
+------------+
| 2019-12-20 |
+------------+
mysql> SELECT CURDATE() + 0;
+---------------+
| CURDATE() + 0 |
+---------------+
| 20191220 |
+---------------+
Keywords
CURDATE,CURRENT_DATE