Wednesday, 4 January 2012

MySql curdate

In MySQL the CURDATE() is used to return the current date in 'YYYY-MM-DD' format or 'YYYYMMDD' format depending on whether numeric or string is used in the function. CURRENT_DATE and CURRENT_DATE() are the synonym of CURDATE().
Note: The outputs depending upon the current date.

 

Syntax

CURDATE ()

 

Example

SELECT CURDATE();

 

Output

MySQL CURDATE()

See also

Mysql curdate function

No comments:

Post a Comment