DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d');

Question

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
哪错了啊

Answer 1

mysql> select DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d'
+-----------------------------------------------+
| DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d') |
+-----------------------------------------------+
| 09-10-10                                      |
+-----------------------------------------------+
1 row in set (0.03 sec)

Answer 2

select DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d')

Answer 3

mysql> select DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d');
+-----------------------------------------------+
| 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>

Answer 4

在php中如何输出啊 主要是这个问题

Answer 5

你到底是在 PHP 中用还是在数据库中用？你可以在PHP中使用 strftime() 函数。

Answer 6

mysql> select DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d');
    -> //
+-----------------------------------------------+
| DATE_FORMAT('2009-10-10 09:17:44','%y-%m-%d') |
+-----------------------------------------------+
| 09-10-10                                      |
+-----------------------------------------------+
1 row in set (0.00 sec)
--------------------------------
没问题
你可以从数据库中查出数据再在页面就行处理