Let SYSDATE = '20-Sep-2012' Use below query, select to

What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

Question Posted / nitin

6 Answers
19599 Views
Cap Gemini, TCS, I also Faced
E-Mail Answers

Answer Posted / nitin

Let SYSDATE = '20-Sep-2012'

Use below query,

select to_char(trunc(add_months(sysdate,-
3),'mm'),'mm/dd/yyyy') from dual;

It will give you ...
o/p :

'06/01/2012'

Is This Answer Correct ?

15 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an oracle stored procedure?

987

Can we insert data into view?

848

what is auto increment? : Sql dba

963

How do you delete a table?

997

Can we use threading in pl/sql?

971

Is sql low level language?

960

what is column? : Sql dba

960

Define the select into statement.

992

Which command is used to delete a package?

1090

Why coalesce is used in sql?

917

What are different types of statements supported by sql?

1096

what is 'mysqlimport'? : Sql dba

974

What does (*) mean in sql?

903

what are the properties and different types of sub-queries? : Sql dba

966

What is pl sql architecture?

921