Posted By

mprabhuram on 08/20/10

Tagged

Viewed 1931 times

Favorited by 0 user(s)

/ Published in: SQL

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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT TO_CHAR(ADD_MONTHS(TO_DATE(TRIM('02/09/2010'),'MM/DD/YYYY'),-3),'YYYYMM')
FROM dual;
 
RESULT : 200911

You need to login to view comments.