MySQL CURDATE() Function Guide
In MySQL, the CURDATE() function is used to return the current date. It does not require any parameters and the date format returned is ‘YYYY-MM-DD’. You can use the CURDATE() function like this:
SELECT CURDATE();
This will return the current date, for example ‘2022-01-01’. You can also combine CURDATE() with other functions and operators to meet your specific needs.