transtime_in, transtime_out
如何获取以下日期时间格式之间的差异:
hh:mm
I use
DATEDIFF(hour, transtime_in, transtime_out)
但我只能得到工作时间。
transtime_in, transtime_out
如何获取以下日期时间格式之间的差异:
hh:mm
I use
DATEDIFF(hour, transtime_in, transtime_out)
但我只能得到工作时间。
DECLARE
@transtime_in DATETIME
, @transtime_out DATETIME
SELECT
@transtime_in = '2013-05-19 08:58:07.000'
, @transtime_out = '2013-05-19 16:40:53.000'
SELECT LEFT(CONVERT(VARCHAR(10), @transtime_out - @transtime_in, 108), 5)
输出:
-----
07:42
declare @D1 datetime
declare @D2 datetime
set @D1 = '2014-03-25 00:00:00.000'
set @D2 = '2014-03-24 17:14:05.000'
--select datediff(hour, cast(@D1 as time(0)), cast(@D2 as time(0)))
SELECT LEFT(CONVERT(VARCHAR(10), @D2 - @D1, 108), 8)
declare @D1 datetime
declare @D2 datetime
set @D1 = '2014-03-25 00:00:00.000'
set @D2 = '2014-03-24 17:14:05.000'
SELECT LEFT(CONVERT(VARCHAR(10), @D1 - @D2, 108), 8)
CONVERT(CHAR(8),GETDATE(),112)
。 - whytheq