The CURDATE() 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 CURDATE() function.
The examples were created with the MyWAY SQL manager: Download
How to use the CURDATE() function in MySQL and MariaDB databases
The CURDATE() function in MySQL and MariaDB is mainly used to get the current date and returns the current date in the format "YYYY-MM-DD". The function is commonly used in SQL queries to filter or compare dates, and for various date calculations.
Further MySQL und MariaDB SQL Date and Time functions