CURDATE() function returns the current day in 'YYYY-MM-DD' or 'YYYYMMDD' format.
SELECT CURDATE()
1999-02-03 (this is just example day, that would have shown on the 3rd of february 1999)
SELECT CURDATE() + 0
19990203 (this is just example day, that would have shown on the 3rd of february 1999)