A general SQL date/time function that returns the current date.

CURRENT_DATE

CURRENT_DATE takes no arguments and returns the date as type DATE. CURRENT_DATE can be used as a default specification.

This example shows how CURRENT_DATE can be used in a SELECT statement to return all records of employees who have a birthday today:

SELECT * FROM Employees 
     WHERE dob = CURRENT_DATE

CURDATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME NOW