Returns the current year, month and day as a DATE value, formatted as YYYY-MM-DD.
DATE
CURRENT_DATE()
SELECT CURRENT_DATE();
Returns: 2021-11-04
2021-11-04