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