Display months quarterly and monthly
Hello All,
I want to display dates with an interval of 1 and three months between two dates
And this is the table :
ID Start_Date End_Date
1 2013-01-14 2013-08-18
2 2013-03-01 2013-09-04
And i had another table separately consisting dates from 2013-01-01 2013-12-31.
Now i want the dates with an interval of 1 and three months between two dates using both these tables
Expected output
ID Date
1 2013-01-14
1 2013-02-14
1 2013-03-14
1 2013-04-14
1 2013-05-14
1 2013-06-14
1 2013-07-14
1 2013-08-14
2 2013-03-01
2 2013-04-01
2 2013-05-01
2 2013-06-01
2 2013-07-01
2 2013-08-01
2 2013-09-01
please help me to write query for that with out creating any extra tables
and for interval of three months
expected output
1 2013-01-14
1 2013-04-14
1 2013-07-14
2 2013-03-01
2 2013-06-01
2 2013-09-01
thanks in advance
Subject
Written By
Posted
Display months quarterly and monthly
July 29, 2013 06:17AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.