echo DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d');
错误如下:
Warning: date_format() expects parameter 1 to be DateTime, string given in /home/content/83/4758483/html/agoodsell/trade/admin_trade.php on line 188
哪错了啊
错误如下:
Warning: date_format() expects parameter 1 to be DateTime, string given in /home/content/83/4758483/html/agoodsell/trade/admin_trade.php on line 188
哪错了啊
+-----------------------------------------------+
| DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d') |
+-----------------------------------------------+
| 09-10-10 |
+-----------------------------------------------+
1 row in set (0.03 sec)
+-----------------------------------------------+
| DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d') |
+-----------------------------------------------+
| 09-10-10 |
+-----------------------------------------------+
1 row in set (0.03 sec)mysql>
mysql> select DATE_FORMAT('2009-10-10 09:17:44','%Y-%m-%d');
+-----------------------------------------------+
| DATE_FORMAT('2009-10-10 09:17:44','%Y-%m-%d') |
+-----------------------------------------------+
| 2009-10-10 |
+-----------------------------------------------+
1 row in set (0.02 sec)mysql>
-> //
+-----------------------------------------------+
| DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d') |
+-----------------------------------------------+
| 09-10-10 |
+-----------------------------------------------+
1 row in set (0.00 sec)
--------------------------------
没问题
你可以从数据库中查出数据再在页面就行处理