日期时间以天为单位统计小时区间时间段数据

最新推荐文章于 2022-11-26 06:52:15 发布

Liang_ZhiQiang

最新推荐文章于 2022-11-26 06:52:15 发布

阅读量1.2k

点赞数

分类专栏： Oracle Database

本文链接：https://blog.csdn.net/liang_zhiqiang/article/details/5887368

版权

Oracle Database 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

select dt,newDate,sum(state) counts from (
select
      convert(varchar(10),createDate,120) as dt,state,
      case when createDate>=cast((convert(varchar(10),createDate,120)+'') as datetime)
      and createDate<cast((convert(varchar(10),createDate,120)+' 09:00:00.000') as datetime)
      then 1
      when createDate>=cast((convert(varchar(10),createDate,120)+' 09:00:00.000') as datetime)
      and createDate<cast((convert(varchar(10),createDate,120)+' 18:00:00.000') as datetime)
      then 2
      when createDate>=cast((convert(varchar(10),createDate,120)+' 18:00:00.000') as datetime)
      and createDate<cast((convert(varchar(10),createDate,120)+' 23:59:59.999') as datetime)
      then 3
      else 4 end newDate
from questionInfo ) o
group by dt,newDate
order by dt