CURRENT DATE returns the current year, month, and day.
DATE
SQL/2008 Vendor extension. In the ANSI SQL/2008 standard, the special register that defines the current date is called CURRENT_DATE.