Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition

Name

CURDATE()

Returns the current date in YYYY-MM-DD or YYYMMDD format, depending on whether the function is used in a numeric or string context. On the date May 2, 2016, the following code will return the values 2016-05-02 and 20160502:

SELECT CURDATE();
SELECT CURDATE() + 0;