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?
Answer Posted / 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 View All Answers
How to do a full database export?
How to define a specific record type?
How to convert a date to char in oracle? Give one example.
How do I know if oracle is installed on windows?
What do you mean by group by clause?
what is the dual table in oracle?
What are data pump export and import modes?
What are the tools for Oracle ?
Why packages are used in oracle?
How to revoke create session privilege from a user in oracle?
How to recover a dropped table in oracle?
Can I create users through internet explorer in oracle 10g?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to run create database statement again?
How to build data dictionary view an new database?