|
mysql>
mysql> SELECT CURDATE();
+------------+
| CURDATE() |
+------------+
| 2007-07-22 |
+------------+
1 row in set (0.00 sec)
mysql> SELECT CURDATE() + 0;
+---------------+
| CURDATE() + 0 |
+---------------+
| 20070722 |
+---------------+
1 row in set (0.00 sec)
mysql>
mysql>
mysql> select CURRENT_DATE();
+----------------+
| CURRENT_DATE() |
+----------------+
| 2007-07-22 |
+----------------+
1 row in set (0.00 sec)
mysql>
mysql>
mysql>
|