SQL CURDATE() returns the current date.

Example

mysql> SELECT CURDATE();
+————+
| CURDATE()  |
+————+
| 2007-05-30 |
+————+
1 row in set (0.00 sec)