What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
- 6 Answers
- 18777 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
what is 'mysqldump'? : Sql dba
How do we use distinct statement? What is its use?
Why we use pl sql?
What is the execution plan in sql?
What is nosql example?
What are the built in functions of sql?
How many disk partitions should I have?
How to connect a sql*plus session to an oracle server?
What is join view in sql?
How many types of index are there?
What is the maximum number of triggers, you can apply on a single table?
What is mutating error in pl sql?
What are the constraints available in sql?
What is not in sql?
What is normalization sql?
