12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
建站问答 时间：2024-12-01 19:17:13
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
mysql中实现按日期排序的方法表结构如下：+---+------------+|id | addtime |+---+------------+| 5 |2020-03-06 |+---+------------+| 6 |2020-03-21 |+---+------------+|
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
表结构如下：
+---+------------+
|id | addtime |
+---+------------+
| 5 |2020-03-06 |
+---+------------+
| 6 |2020-03-21 |
+---+------------+
| 7 |2020-03-29 |
+---+------------+
1.首先，在表中利用DATE_FORMAT函数对表的日期进行格式化；
select * from browser_history where date_format(addtime,'%Y-%m-%d') = '2019-03-06';
2.表中的日期格式化好后，执行以下命令即可对日期进行排序；
select DATE_FORMAT(addtime,"%Y-%m-%d") as ndate from browser_history where uid = 822 group by ndate
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19