Make a range of months between a period of 3 months

Question

1.00/5 (1 vote)

See more:

I want to make a select that gives me a range of months between a period of 3 months.

Like that:

MONTH | YEAR
-----------------------
08 | 2019
11 | 2019
02 | 2020
05 | 2020
08 | 2020

What I have tried:

i want result like this for quarterly report purpose

Posted 8-Aug-19 1:09am

Member 10493886

Updated 8-Aug-19 5:41am

Add a Solution

Comments

CHill60 8-Aug-19 7:35am

The "What I have tried:" section is for you to put the code that you have tried. We don't write code to order.

OriginalGriff 8-Aug-19 8:19am

What have you tried?
Where are you stuck?
What help do you need?

Benktesh Sharma 8-Aug-19 8:25am

Are you looking at raw dates and get the range of months beginning from the first date? Or you just want to create a list starting with 08/2019 and values 3 months after each of those?

Also, are you looking in strictly SQL or C# or other language?

OriginalGriff 8-Aug-19 9:57am

Hint: That's why questions have tags on them ...

Benktesh Sharma 8-Aug-19 10:29am

:). The tags are Oracle, VB.NET, ASP.NET4 and that's why I asked a language-specific question.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MadMyche · Answer 1 · 2019-08-08T05:30:00

Solution 1

Oracle, like most SQL databases; has a BETWEEN condition which would probably be a good place to start.

SQL

SELECT *
FROM order_details
WHERE order_date BETWEEN TO_DATE ('2014/02/01', 'yyyy/mm/dd')
AND TO_DATE ('2014/02/28', 'yyyy/mm/dd');

Reference: Oracle / PLSQL: BETWEEN Condition[^]

Posted 8-Aug-19 5:30am

MadMyche

Wendelius · Answer 2 · 2019-08-08T05:41:00

Perhaps a recursive CTE is what you're after, something like

SQL

WITH Months (ActualDate) AS (
   SELECT TO_DATE('01.08.2019', 'DD.MM.YYYY') AS ActualDate
   FROM Dual
   UNION ALL
   SELECT ADD_MONTHS(a.ActualDate, 3)    AS ActualDate
   FROM   Months a
   WHERE  a.ActualDate <= TO_DATE('01.08.2020', 'DD.MM.YYYY')
)
SELECT m.ActualDate,
       TO_CHAR(m.ActualDate, 'MM') AS Month,
       TO_CHAR(m.ActualDate, 'YYYY') AS Year
FROM   Months m;