CURRENT_DATE

Provide the date of today.

SELECT CURRENT_DATE();

Definition and Usage

The CURRENT_DATE() function yields the present date.

Please note that the date is provided in either “YYYY-MM-DD” (string) or YYYYMMDD (numeric) format.

Note: This function is equivalent to the CURDATE() function.

CURRENT_DATE()

Works in:

From MySQL version 4.0

Provide the date that follows the current date by one day.

SELECT CURRENT_DATE() + 1;