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
7248 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

Explain the use of Merge statement in oracle 11g

975

Name the three major set of files on disk that compose a database in Oracle?

1063

How to define a sub function?

1083

What do you mean by redo log file mirroring?

975

Explain the use of indexes option in imp command.

1085

Explain an index segment?

1040

How to call a stored function with parameters?

969

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2063

What is a package ? What are the advantages of package ?

1033

What are the ways tablespaces can be managed and how do they differ?

2270

How to compare dates in oracle sql?

1041

Is oracle a relational database?

870

Explain the use of analyse option in exp command.

1064

What are operators in oracle?

1009

Does facebook use oracle?

979