CURDATE() FUNCTION in MySQL

CURDATE() FUNCTION
The MySQL CURDATE function is used to get the current date. The various versions of MySQL supports 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( )

Example 1:

mysql> SELECT CURDATE ();

Output:

'2019-07-05'

Explanation:
The current date has been returned as the result.

Example 2:

mysql> SELECT CURDATE () + 2;

Output:

'20190707'

Explanation:
Two days after the current date has been returned as the result.

Please Share