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
19793 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 attribute indicator in pl sql?

1009

What is Histogram?

1554

Where not exists in sql?

971

what is single byte over head in oracle..?

2397

Explain the difference in execution of triggers and stored procedures?

1014

how many columns can be used for creating index? : Sql dba

940

How can use stored procedures in sql?

1134

What sql database should I use?

1136

Is progress software supports to ( pl/sql )?

1033

What schema means?

884

What are all the ddl commands?

1177

what is the difference between $message and $$message? : Sql dba

992

Why truncate is used in sql?

998

What found sql?

938

What is linq to sql?

1129