获得时间差

Question

select cast(datediff(minute,'2004-10-06',getdate())/60.0 as decimal(18,2))

Answer 1

select cast(cast(datediff(mi,起始时,终止时间) as numeric(8,2))/60 as numeric(8,2))

Answer 2

你是需要得到小时数吧？
select cast(cast(datediff(hh,起始时,终止时间) as numeric(8,2))/60 as numeric(8,2))

Answer 3

select convert(nvarchar(8),time1,108),convert(nvarchar(8),time2,108),
convert(decimal(8,2),(datediff(mi,convert(nvarchar(8),time1,108),convert(nvarchar(8),time2,108))/60 )) from table