Oracle 查询当前日期的前几个月时间
select sysdate from dual
2016-2-25 10:34:41
select ADD_MONTHS(to_date(to_char(sysdate,'yyyy-mm'),'yyyy-mm'),-3) from dual
2015-11-1
Oracle 查询当前日期的前几个月时间
select sysdate from dual
2016-2-25 10:34:41
select ADD_MONTHS(to_date(to_char(sysdate,'yyyy-mm'),'yyyy-mm'),-3) from dual
2015-11-1
转载于:https://my.oschina.net/u/1028135/blog/621696