sql 日期語法 抓上個月的年月

1.
SELECT YEAR(DATEADD(MOHTH,-1,日期)) AS y, MONTH(DATEADD(MOHTH,-1,日期)) AS m

2.
INSERT INTO ( cdate ) values (select TO_CHAR(ADD_MONTHS(sysdate,-1),'yyyymm') from dual )