Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7279 Views
- Philips, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Explain the types of exception?
What is the use of oracle?
How to select some columns from a table in oracle?
How to install oracle odbc drivers?
Explain the family trees and connection by clause
What do you mean by cdb and pdb in oracle 12c?
Is primary key indexed by default in oracle?
What are the parameters that we can pass through a stored procedure?
What are the set operators union, union all, minus & intersect meant to do?
What do you understand by database schema and what does it hold?
How remove data files before opening a database?
What is SQL Tuning Advisor in Oracle?
Oracle General 
