select WorkDay,
MIN(WorkDay) as dayOn,
MAX(WorkDay) as DayOff
from Records
where YEAR(WorkDay)=2014 and MONTH(WorkDay) =10 and EnNo=10
group by WorkDay
查询显示结果如下
WorkDays DayOn Dayoff
2014-10-04 08:13:00.000 2014-10-04 08:13:00.000 2014-10-04 08:13:00.000
2014-10-04 17:19:00.000 2014-10-04 17:19:00.000 2014-10-04 17:19:00.000
但是我需要类似下面的数据
WorkDays DayOn Dayoff Oct
2014-10-04 2014-10-04 08:13:00.000 2014-10-04 17:19:00.000
有人请整理此查询谢谢,
select WorkDay = cast(floor(cast(WorkDay as float)) as datetime),
MIN(WorkDay) as dayOn,
MAX(WorkDay) as DayOff
from Records
where YEAR(WorkDay)=2014 and MONTH(WorkDay) =10 and EnNo=10
group by cast(floor(cast(WorkDay as float)) as datetime)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句