Get current date in MySQL

SELECT id, deadline, CURDATE() AS 'currentDate' FROM task WHERE deadline > CURDATE();

In MySQL you can get the actual date, using the built-in CURDATE() function. CURDATE() returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context.

In other SQL code, you may also see the CURRENT_DATE() function, which is a synonym for CURDATE() . You can use both either in a WHERE condition or as a selected column.