sql查询时间段数据

select * from tablename t where t.createdtime>=trunc(SYSDATE, 'MM') and t.createdtime<=last_day(SYSDATE)

-----------当月的数据
select * from integral_list t where t.update_time >=trunc(SYSDATE, 'MM') and t.update_time <=last_day(SYSDATE)

----------半年数据
select count(*) from integral_list t where t.update_time >=add_months(sysdate,-6) and t.update_time <=sysdate

select count (*) from integral_list t where t.update_time >=add_months(sysdate,-12) and t.update_time <=sysdate

select count(*) from integral_list t

----------半年时间
select sysdate time1,add_months(sysdate,-6) time2 from dual

----------一年时间
select sysdate time1,add_months(sysdate,-6) time2 from dual

 

----------三个月的数据
select sysdate time1,add_months(sysdate,3) time2 from dual

select sysdate, add_months(sysdate,4) from dual ;

select