作者shadowjohn (3WA問題解決專家)
看板PHP
標題Re: [請益] 資料庫日期排序錯誤(date)
時間Tue Aug 31 14:29:19 2010
localtime 是保留字，請記得用 ` ` 框起來
mysql> select * from `questions` order by `localtime`;
+------+------------+
| id | localtime |
+------+------------+
| 1 | 2009-11-03 |
| 5 | 2009-11-03 |
| 3 | 2010-01-05 |
| 7 | 2010-02-08 |
| 2 | 2010-02-09 |
| 6 | 2010-02-09 |
| 4 | 2010-02-10 |
+------+------------+
7 rows in set (0.00 sec)
mysql> select * from questions order by localtime;
+------+------------+
| id | localtime |
+------+------------+
| 1 | 2009-11-03 |
| 5 | 2009-11-03 |
| 3 | 2010-01-05 |
| 4 | 2010-02-10 |
| 2 | 2010-02-09 |
| 7 | 2010-02-08 |
| 6 | 2010-02-09 |
+------+------------+
7 rows in set (0.00 sec)
mysql>
--
3WA訓練家的工作室
宗旨：諸葛單中，謝謝
個人佈弱格 網址：
http://3wa.tw
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.32.9.79