Logic to subtract months from a date field and extract run_yr_mo

Revision: 30716

at August 20, 2010 00:17 by mprabhuram

Initial Code

select TO_CHAR(ADD_MONTHS(TO_DATE(TRIM('02/09/2010'),'MM/DD/YYYY'),-3),'YYYYMM')
from dual;

Result : 200911

Initial URL

Initial Description

Logic to subtract months from a date field and extract year and month

Initial Title

Logic to subtract months from a date field and extract run_yr_mo

Initial Tags

Oracle

Initial Language

SQL