CURRENT_DATE

Returns the current year, month and day as a DATE value, formatted as YYYY-MM-DD.

Syntax

CURRENT_DATE()

Example

SELECT
    CURRENT_DATE();

Returns: 2021-11-04