Hi all,
I need to return the date by taking the maximum date and subtracting 3 months before that date
For ge if the maximum date is 31/12/2003 i need to get the that date which is beyond 3 months of this date
Thanks all
Anu
Printable View
Hi all,
I need to return the date by taking the maximum date and subtracting 3 months before that date
For ge if the maximum date is 31/12/2003 i need to get the that date which is beyond 3 months of this date
Thanks all
Anu
SELECT TO_DATE('31.12.2003','dd.mm.yyyy') date_orig,
ADD_MONTHS (TO_DATE('31.12.2003','dd.mm.yyyy'), -3) date_3_months_before
FROM dual
Thanks a lot