select id from a
where to_char( Your_Date_Column,'YYYYMMDD') >= '20040501'
and to_char( Your_Date_Column,'YYYYMMDD') >= '20040601'
where to_char( Your_Date_Column,'YYYYMMDD') >= '20040501'
and to_char( Your_Date_Column,'YYYYMMDD') >= '20040601'
select id from a
where to_char( Your_Date_Column,'YYYYMMDD') >= '20040501'
and to_char( Your_Date_Column,'YYYYMMDD') <= '20040601'
round(sysdate,'yyyy')
round(sysdate,'mm')
round(sysdate,'d')
上面三个函数可求出本年,本月,本周的截止日期。
add_months(round(sysdate,'mm'),-12)
add_months(round(sysdate,'mm'),-1)last_day(trunc(sysdate))月底最后一天
select * from table_name where to_char(col_date,'yyyymmdd')||to_char(col_date,'w')=to_char(sysdate,'yyyymmdd')||to_char(sysdate,'w')
本月:
select * from table_name where to_char(col_date,'yyyymm')=to_char(sysdate,'yyyymm')
本年:
select * from table_name where to_char(col_date,'yyyy')=to_char(sysdate,'yyyy')