34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT DATEDIFF( mi, '2013-03-04 15:30:00.000', '2013-03-04 17:00:00.000')*1.0/60
DECLARE @a DATETIME,@b DATETIME
SELECT @a='2013-03-04 15:30:00.000',@b= '2013-03-04 17:00:00.000'
SELECT DATEDIFF(minute,@a,@b)/60.0
select datediff(minute,'2013-03-04 15:30:00.000','2013-03-04 17:00:00.000')/60.0
SELECT substring(cast(DATEDIFF( mi, '2013-03-04 15:30:00.000', '2013-03-04 17:00:00.000')/60.0 as varchar),1,3)
SELECT SUBSTRING((SELECT DATEDIFF( mi, '2013-03-04 15:30:00.000',
'2013-03-04 17:00:00.000')/60.0), 1,3)