This tutorial explains how to use the MySQL CURRENT_DATE function with syntax and examples.
The MySQL CURRENT_DATE function returns the current date.
The syntax for the CURRENT_DATE function in MySQL is:
CURRENT_DATE( )
There are no parameters or arguments for the CURRENT_DATE function.
The CURRENT_DATE function can be used in the following versions of MySQL:
Let's look at some MySQL CURRENT_DATE function examples and explore how to use the CURRENT_DATE function in MySQL.
For example:
mysql> SELECT CURRENT_DATE();
Output: '2014-01-28'
mysql> SELECT CURRENT_DATE() + 0;
Output: 20140128
mysql> SELECT CURRENT_DATE() + 1;
Output: 20140129