oracle日期函数备忘

                                                                  常用日期型函数

S y s d a t e 当前日期和时间Select sysdate from dual； 28-FEB-02 on February 28,2002

L a s t _ d a y 本月最后一天Select last_day(sysdate) from dual； 31-MAR-02 on March 12,2002

A d d _ m o n t h s ( d , n ) 当前日期d后推n个月Select add_months(sysdate,2) from dual  1 8 - M AY-02 on March 18,2002

M o n t h s _ b e t w e e n ( f , s ) 日期f和s间相差月数Select months_between(sysdate,'12-MAR,-02')from dual；13 in April 2003

N e x t _ d a y ( d , d a y ) d后第一周指定的day日期 Select next_day(sysdate,'Monday') from dual;03-JAN-02 on December30,2001