Re: [請益] 資料庫日期排序錯誤(date)
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
討論串 (同標題文章)
完整討論串 (本文為第 2 之 2 篇)：
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
