sql計(jì)算時(shí)間差得到時(shí)分秒？declare @starttime as datetimedeclare @endtime as datetimeset @starttime = "2009-11-21

sql計(jì)算時(shí)間差得到時(shí)分秒？

declare @starttime as datetime

declare @endtime as datetime

set @starttime = "2009-11-21 00:00:00"

set @endtime = "2009-11-24 15:12:24"select right("00" cast(cast(datediff(ss ，@starttime，@endtime) / 3600 as int) as varchar)，2) ":"

right("00" cast(cast(datediff(ss ，@starttime，@endtime) % 3600 / 60 as int) as varchar)，2) ":"

right("00" cast(cast(datediff(ss ，@starttime，@endtime) % 60 as int) as varchar)，2) as 時(shí)間差

時(shí)間差

--------------

87:12:24(1 行受影響)

SQL里邊怎么計(jì)算兩個(gè)時(shí)間差？

DATEDIFF(mi，開始時(shí)間，結(jié)束時(shí)間) 這個(gè)函數(shù)可以算出會(huì)話時(shí)間，mi代表分鐘，1。兩張表匹配下，sum（算出的會(huì)話時(shí)間）即可2.select 訪問客戶，sum（算出的會(huì)話時(shí)間） from ... group by 訪問客戶3.用agv（算出的會(huì)話時(shí)間) 即可4.select 訪問客戶，agv（算出的會(huì)話時(shí)間） from ... group by 訪問客戶

用SQL語句怎么寫時(shí)間差？

加上表頭 地區(qū) 時(shí)間，用sql in Excel來解決，大概的語句如下：select 地點(diǎn)，max(時(shí)間)-min(時(shí)間) as 停留時(shí)長(zhǎng) from (select * from 表1$a:b union all select * from 表1$c:d) group by 地點(diǎn)思路：添加表頭，將兩列數(shù)據(jù)合并，然后按地區(qū)聚合，按照最大時(shí)間-最小時(shí)間算出時(shí)間差 作為停留時(shí)長(zhǎng)，當(dāng)然停留時(shí)長(zhǎng)如果需要顯示格式（按天，按小時(shí)）上述語句中還需添加換算。