CURRENT_DATE() function returns the current day in 'YYYY-MM-DD' format.

Example

SELECT CURRENT_DATE()

Returns

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