Oracle中日期查询

Oracle中日期查询

//得到天数差

select to_date('2009-01-31','mm')-to_date('2009-02-28','mm') ts from dual;

 

//得到某日期的月/天

select to_char(trunc(sysdate),'mm') from dual

select to_char(trunc(sysdate),'dd') from dual