select to_char(trunc(add_months(sysdate,-3),'mm'),'mm/dd/yyy

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

Question Posted / sreeharibabu

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

Answer Posted / sreeharibabu

select to_char(trunc(add_months(sysdate,-3),'mm'),'mm/dd/yyyy') from dual;--sysdate:22-APR-2016 output :01/01/2016
-- corrections in add_months , mm ,mm/dd/yyyy
--- flow--
select add_months(sysdate,-3) from dual;--sysdate:22-APR-2016 -- output : 1/22/2016 8:15:24 AM

select trunc(add_months(sysdate,-3),'mm') from dual;--sysdate:22-APR-2016 output : 01/01/2016

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Are sql connections encrypted?

1034

What are packages in pl sql and also explain its advantages?

1045

What are three advantages to using sql?

1025

Which one is better sql or oracle?

975

What are the parts of a sql statement?

1091

How does cross join work in sql?

1023

What is string join?

981

What is sql performance tuning?

927

what is clause? : Sql dba

1066

how to use like conditions? : Sql dba

1115

What is sharding in sql?

994

What are different functions in sql?

951

What is a table in a database?

1052

Is left join same as inner join?

1137

What is record in pl sql?

1090