CURDATE()

MySQL 8.4

Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in string or numeric context.

Syntax

MYSQL

SELECT CURDATE();
'2008-06-13'
SELECT CURDATE() + 0;
20080613

Example

MYSQL

SELECT CURDATE();
'2008-06-13'
SELECT CURDATE() + 0;
20080613