• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1634
  • Last Modified:

current quarter and four future quarters

Hello Experts,

How to display current quarter and four future quarters using sysdate??

select 'Q'||to_char(sysdate,'Q')||'-'||to_char(sysdate,'YYYY') from dual;
Q4-2007
I want to generate the following:
Q4-2007
Q1-2008
Q2-2008
Q3-2008
Q4-2008
Thanks,
0
spsun
Asked:
spsun
1 Solution
 
radja7Commented:

SELECT 'Q'||to_char(dat,'Q')||'-'||to_char(dat,'YYYY') 
FROM (
  SELECT sysdate+(level-1)*91 as dat 
  FROM dual CONNECT BY level<=5
);

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now