MySQL Forums
Forum List  »  Newbie

Display months quarterly and monthly
Posted by: K CH GANESH CHOWDARY S
Date: July 29, 2013 06:17AM

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

Options: ReplyQuote


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.