MySQL CURRENT_DATE

Syntax :

CURRENT_DATE( )

MySQL CURRENT_DATE() function returns the current date.

MySQL CURRENT_DATE() function returns the current date in 'YYYY-MM-DD' format in string or 'YYYYMMDD' format in numeric

Examples of CURRENT_DATE() Function

mysql> SELECT CURRENT_DATE();

// output : 2022-07-29

mysql> SELECT CURRENT_DATE()+0;

// output : 20220729