文章目录
[+]
先用unix_timestamp将韶光转换为韶光戳,然后两个韶光相减,即可得到相减的秒数~搞定
select id,(unix_timestamp(offline_time)-unix_timestamp(online_time))`在线时长/秒`From tablenamewhere id='1111'and dt='2018-08-29'

(图片来自网络侵删)
扫一扫用手机浏览
先用unix_timestamp将韶光转换为韶光戳,然后两个韶光相减,即可得到相减的秒数~搞定
select id,(unix_timestamp(offline_time)-unix_timestamp(online_time))`在线时长/秒`From tablenamewhere id='1111'and dt='2018-08-29'