CURDATE() FUNCTION
The MySQL CURDATE function is used to get the current date. The various versions of MySQL support the CURDATE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.
Syntax:
CURDATE( )
CURDATE( )
CURDATE( )
Example 1:
mysql> SELECT CURDATE ();
mysql> SELECT CURDATE ();
mysql> SELECT CURDATE ();
Output:
'2019-07-05'
'2019-07-05'
'2019-07-05'
Explanation:
The current date has been returned as the result.
Example 2:
mysql> SELECT CURDATE () + 2;
mysql> SELECT CURDATE () + 2;
mysql> SELECT CURDATE () + 2;
Output:
'20190707'
'20190707'
'20190707'
Explanation:
Two days after the current date has been returned as the result.