I need to get the values of the previous quarter.how to do this?eg: if my cuur

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 / sudhir

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

Answers were Sorted based on User's Feedback

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i n..

Answer / 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

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i n..

Answer / jas

yes its possible...u can use the date functions
select * from table_name where col_name
between add_months (trunc(sysdate,'MONTH')-3)
and trunc(sysdate,'MONTH')-1

try usgin this might help..

Is This Answer Correct ?

1 Yes

2 No

Post New Answer