Date Time MySQL

/*
mysql> SELECT CURRENT_DATE;
+--------------+
| CURRENT_DATE |
+--------------+
| 2005-10-09   |
+--------------+
1 row in set (0.00 sec)
*/  
/* SELECT CURRENT_DATE; */
SELECT CURRENT_DATE;