CURDATE() function returns the current day in 'YYYY-MM-DD' or 'YYYYMMDD' format.

Example

SELECT CURDATE()

Returns

1999-02-03 (this is just example day, that would have shown on the 3rd of february 1999)

 

Example 2

SELECT CURDATE() + 0

Returns

19990203 (this is just example day, that would have shown on the 3rd of february 1999)