MySQL CURRENT_DATE: Usage & Examples

In MySQL, CURRENT_DATE is a system function that returns the current date formatted as YYYY-MM-DD. You can use CURRENT_DATE in a SELECT statement to fetch the current date value, for instance:

SELECT CURRENT_DATE;

This will return a date string similar to 2022-04-15. The CURRENT_DATE function is often used to insert the current date value into a table, or for filtering and comparing date values.