DATE CURDATE()
Get the current date and return it in Date type
mysql> SELECT CURDATE(); +------------+ | CURDATE() | +------------+ | 2019-12-20 | +------------+ mysql> SELECT CURDATE() + 0; +---------------+ | CURDATE() + 0 | +---------------+ | 20191220 | +---------------+
CURDATE,CURRENT_DATE