KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
See the results of below queries: >> SELECT ADD_MONTHS(TO_DATE('30-MAR-11','DD-MON-RR'),-4) FROM DUAL; 30-NOV-10 >> SELECT ADD_MONTHS(TO_DATE('30-NOV-10','DD-MON-RR'),4) FROM DUAL; 31-MAR-11 How can I get '30-MAR-11' when adding 4 months to some date? Please help.
Tags (comma-separated)
Save Edits
Cancel