有用的oracle 日期

select extract(year from EXECUTION_END_DATE ) as 年度, extract(month from EXECUTION_END_DATE ) as 月份,
       DEPARTMENT_ID,count(FORM_NO) CIP數
from cip_master
group by extract(year from EXECUTION_END_DATE),extract(month from EXECUTION_END_DATE),DEPARTMENT_ID
having extract(year from EXECUTION_END_DATE) =2009 and extract(month from EXECUTION_END_DATE) in (1)
order by DEPARTMENT_ID

 

select * from ess_speakout
where substr(to_char(SPEAKOUT_DATE,'YYYY/MM/dd'),6,2) =extract(month from sysdate)