标题 sql 语句
查询条件:根据当前时间查询
select employeeCode,type,sum(cast(day as float))as day from view_jijian_holidaywhere startTime>=cONVERT( datetime, CONVERT( char(8), getdate(),120) + ’ 1 ')
and
endTime<=DATEADD( Day, -1, CONVERT( char(8), DATEADD( Month,1, getdate()),120) + ’ 1 ')
and employeeCode=‘234059’
group by employeeCode,type