SQL日期字段查询和日期相减得到小时数并保留2位小数

1、得到日期字段的不同格式

select RecordTime from [192.168.30.2].[SmartChargeLaiBao].[dbo].[HRVisitTime] a

select convert(char(10),RecordTime,120) from [192.168.30.2].[SmartChargeLaiBao].[dbo].[HRVisitTime] a

select CONVERT(varchar, RecordTime, 120 ) from [192.168.30.2].[SmartChargeLaiBao].[dbo].[HRVisitTime] a

以下分别对应以上三种查询结果：

 

2、日期相减得到小时数并保留2位小数

select datediff(hh,SJKSSJ,SJJSSJ),SJKSSJ,SJJSSJ,CAST(datediff(minute, SJKSSJ,SJJSSJ)/60.00 AS decimal(9,2)) as cycleDate from JBSQ