56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> select curdate();
+------------+
| curdate() |
+------------+
| 2009-11-02 |
+------------+
1 row in set (0.06 sec)
mysql>
mysql> select date_format(curdate(),'%y-%m-%d %H:%i:%s');
+--------------------------------------------+
| date_format(curdate(),'%y-%m-%d %H:%i:%s') |
+--------------------------------------------+
| 09-11-02 00:00:00 |
+--------------------------------------------+
1 row in set (0.00 sec)
mysql>
SELECT DATE_ADD(CURDATE(), INTERVAL -2 HOUR)
SELECT CAST(CURDATE() AS DATETIME)
SELECT CAST(CURDATE() AS DATETIME)