Mysql中实现按时间戳排序的方法首先,首先创建一个数据表;create table DemoTable(`timestamp` varchar(100));数据表创建好后,向表中插入时间戳数据;insert into DemoT
首先,首先创建一个数据表;
create table DemoTable
(
`timestamp` varchar(100)
);
数据表创建好后,向表中插入时间戳数据;
insert into DemoTable values('06/22/2019 01:10:20 PM');
insert into DemoTable values('06/22/2019 12:00:27 PM');
insert into DemoTable values('06/22/2019 06:56:20 AM');
insert into DemoTable values('06/22/2019 07:10:11 AM');
时间戳数据插入后,查看表结构;
select *from DemoTable;
+------------------------+
| timestamp |
+------------------------+
| 06/22/2019 01:10:20 PM |
| 06/22/2019 12:00:27 PM |
| 06/22/2019 06:56:20 AM |
| 06/22/2019 07:10:11 AM |
+------------------------+
4 rows in set (0.00 sec)
通过执行以下命令对表中的时间戳进行排序;
select *from DemoTable ORDER BY STR_TO_DATE(`timestamp`,'%m/%d/%Y%h:%i:%s %p');
最后,时间戳排序好后,继续查看表结构,即可看到时间戳排序成功;
select *from DemoTable;
+------------------------+
| timestamp |
+------------------------+
| 06/22/2019 06:56:20 AM |
| 06/22/2019 07:10:11 AM |
| 06/22/2019 12:00:27 PM |
| 06/22/2019 01:10:20 PM |
+------------------------+
4 rows in set (0.00 sec)
--结束END--
本文标题: mysql如何时间戳排序
本文链接: https://www.lsjlt.com/news/116318.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-14
2024-05-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0