1、案例:
--整月,如果日期格式为字符串:
select count(*) from tname where
DDATE> = trunc(to_date('2019/7/2' , 'yyyy-mm-dd'), 'mm') and
DDATE<ADD_MONTHS(trunc(to_date('2019/7/2' , 'yyyy-mm-dd'), 'mm'),1)
--整月,如果日期格式为date:
select count(*) from tname where
DDATE> = trunc('2019/7/2' , 'mm') and
DDATE<ADD_MONTHS(trunc('2019/7/2' , 'mm'),1)
--整年
DDATE> = trunc(to_date('2019/7/5' , 'yyyy-mm-dd'), 'yyyy') and
DDATE<ADD_MONTHS(trunc(to_date('2019/7/20' , 'yyyy-mm-dd'), 'yyyy'),12)