SCOTT.EMP TABLE WITH HIREDATE AS COLUMN : select hiredate, decode (mod

I need to get the values of the previous quarter.how to do
this?eg: if my cuurent month is may i need to get the datas
of the month jan,feb,march.Can it be done in oracle.I tried
with date function q but for the month jan its not
retriving the previous quarter(oct-dec).how to solve
this.plpz anyone help me?

Question Posted / aseem k

2 Answers
7552 Views
Philips, I also Faced
E-Mail Answers

Answer Posted / aseem k

SCOTT.EMP TABLE WITH HIREDATE AS COLUMN :

select hiredate,
decode (mod(to_number(to_char(hiredate,'mm')) ,
3 ),0,add_months(last_day(hiredate)+1,-6),1,add_months
(last_day(hiredate)+1,-4),2,add_months(last_day(hiredate)
+1,-5)) "first day OF PREVIOUS QUARTER",
decode (mod(to_number(to_char(hiredate,'mm')) ,
3 ),0,add_months(last_day(hiredate),-3),1,add_months
(last_day(hiredate),-1),2,add_months(last_day(hiredate),-
2)) "last day OF PREVIOUS QUARTER"
from emp

REGARDS
ASEEM

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is transport network substrate (tns) in oracle?

1096

What exactly do quotation marks around the table name do?

1027

Query to retrieve record for a many to many relationship ?

2577

How many types of tables supported by oracle?

1121

What is format trigger?

2121

What are temporal data types in oracle?

1171

How to view existing locks on the database?

1103

Please explain compound trigger in oracle?

1111

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1094

interview questions with answer for cts

2638

Explain an extent?

1158

What is oracle database client?

1082

What is set operator oracle?

1036

How to export several tables together?

1106

What is the maximum number of triggers that can be applied to a single table?

1069