?
Solved

current quarter and four future quarters

Posted on 2007-11-30
1
Medium Priority
?
1,605 Views
Last Modified: 2013-12-07
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
Comment
Question by:spsun
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 4

Accepted Solution

by:
radja7 earned 1000 total points
ID: 20386296

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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question