The CURRENT_DATE() function returns the current date as a string YYYY-MM-DD or numerically as BIGINTYYYYMMDD or as DECIMALYYYYMMDD.microseconds depending on whether the function is in string or numeric format context is used.
The value is expressed in the format of the current session time zone.
Setting the system variable timestamp affects the CURRENT_DATE() function.
The examples were created with the MyWAY SQL manager: Download
How to use the CURRENT_DATE() function in MySQL and MariaDB databases
The CURRENT_DATE() function in MySQL and MariaDB is mainly used to get the current date and is frequently used to filter or compare dates in SQL queries and for various date calculations. The function returns the current date in the format "YYYY-MM-DD".
Further MySQL und MariaDB SQL Date and Time functions