博客内容展示了在SQL中如何使用UNIX_TIMESTAMP、TIMESTAMPDIFF函数计算时间戳之间的差距，包括秒、分钟、小时和天数，涉及时间间隔的转换和计算。
select (UNIX_TIMESTAMP('2022-04-11 23:56:37') - UNIX_TIMESTAMP('2022-04-11 22:56:00'))/60 dif_minute from dual 60.6167分
select (UNIX_TIMESTAMP('2022-04-12') - UNIX_TIMESTAMP('2022-04-11')) dif_minute from dual 86400秒=24个小时
select TIMESTAMPDIFF(day,'2022-04-11','2022-04-13') from dual 2天
select TIMESTAMPDIFF(minute,'2022-04-11','2022-04-12') from dual 1440分钟
select TIMESTAMPDIFF(hour,'2022-04-11','2022-04-12') from dual 24小时
select TIMESTAMPDIFF(second,'2022-04-11','2022-04-12') from dual 86400秒=24个小时
select TIMESTAMPDIFF(second,'2022-04-11 00:00:00','2022-04-12 00:00:01') from dual 86401秒
select TIMESTAMPDIFF(minute,'2022-04-11 00:00:00','2022-04-13 01:00:00') from dual 2940分钟=49个小时
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
