「Oracle」ADD_MONTHSで月を減算するサンプル
1.システム日付を取得
SELECT
TO_CHAR(SYSDATE, 'YYYYMM') AS CFT
FROM
DUAL
SELECT
TO_CHAR(SYSDATE, 'YYYYMM') AS CFT
FROM
DUAL
SELECT TO_CHAR(SYSDATE, 'YYYYMM') AS CFT FROM DUAL
結果
CFT
202108
2.現在日から36ヶ月(3年)前を取得
SELECT
TO_CHAR(ADD_MONTHS(SYSDATE, - 36), 'YYYYMM') AS
CFT
FROM
DUAL
SELECT
TO_CHAR(ADD_MONTHS(SYSDATE, - 36), 'YYYYMM') AS
CFT
FROM
DUAL
SELECT TO_CHAR(ADD_MONTHS(SYSDATE, - 36), 'YYYYMM') AS CFT FROM DUAL
結果
CFT
201808