Question

oracle查询每天某个时间段的数据

select DEPARTMENT,SEC_YEAR_PLAN,SEC_YEAR_PLAN,SEC_DAY_COM,SEC_MONTH_COUNT,SEC_YEAR_COUNT,ASS_YEAR_PLAN,ASS_MONTH_PLAN,ASS_DAY_COM,ASS_MONTH_COUNT,ASS_YEAR_COUNT,TEM_DAY_SPIN,TEM_DAY_CHANGE,TEM_DAY_BOX,TEM_DAY_OTHER,TEM_COM_TOTALTEM_DAY_GROUP,TEM_MONTH_COUNT,TEM_YEAR_COUNT from
VEHICLE_CAR_TASK t where to_char(t.CREATE_TIME,'hh24') between "7" and "7"

Answer 1

根据时间范围查询就好了，比如:
select * from a where a.create_date between to_date('20170101','yyyy/mm/dd') and to_date('20170531','yyyy/mm/dd')

Answer 2

你想问什么？