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

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

Question Posted / rajeev

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

Answer Posted / rajeev

select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual--This query will return error...
we can use below query..
select to_char(trunc(add_months(sysdate-1,3),'mm'),'mm/dd/yyyy') from dual;
output:05/01/2018

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does bitemporal mean?

1055

What is a sql select statement?

1030

what is 'mysqlimport'? : Sql dba

1035

What are the different sql commands?

1061

Can two tables have same primary key?

961

Does normalization improve performance?

1025

How do you go back in sql?

980

How does sql profiler work?

1008

Inline the values in PL/SQL, what does it mean.?

1211

what is sql profiler? : Sql dba

1030

How do you select unique values in sql?

993

Can unique keys be null?

894

Give the order of sql select?

1129

How can we optimize a sql query?

1041

How long will it take to learn pl sql?

932