how to write a sql producing data ranges from a given date

[Grace Green]

Hi,

I am not an expert in SQL, and I need to figure out the following:
- given a start date, output the 12 months date ranges until the date range that includes today

For instance, the start date is 10 June 2010, the date range I should produce would be
10 June 2010-10 June 2011
10 June 2011-10 June 2012
10 June 1012-10 June 2013
10 June 2013-10 June 2014 <--- this includes today's date of 1 July 2013.

Could anyone help ?
Thank you !

[Lukas Eder]

First off, what database is this for?

In Oracle, you could use CONNECT BY to generate records for all dates between a given input date and today:

SELECT add_months(input, (level - 1) * 12) start_date, add_months(input, level * 12) end_date FROM ( -- Set the input date here SELECT DATE '2010-06-10' input FROM DUAL ) CONNECT BY add_months(input, (level - 1) * 12) < sysdate

See this SQL Fiddle here for details:
http://sqlfiddle.com/#!4/d41d8/14448