Explain Current_Date Function in SQL?

Programming Language
#1

The MySQL CURRENT_DATE function returns the current date.

Syntax:

The syntax for the CURRENT_DATE function in MySQL is:

CURRENT_DATE( )

Parameters and Arguments:

There are no parameters or arguments for the CURRENT_DATE function.

Note:

  • The CURRENT_DATE function will return the current date as a ‘YYYY-MM-DD’ format, if used in a string context.
  • The CURRENT_DATE function will return the current date as a YYYYMMDD format, if used in a numeric context.
  • The CURRENT_DATE function is a synonym for the CURDATE function.