Returns the current date.

 

Example:

SELECT CURRENT_DATE() returns 9/13/01 (for example)