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