Returns the current date.

 

Example:

SELECT CURDATE() returns 9/13/01