What will be the output of this Query?
select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
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 trigger in pl sql with examples?
What is a left inner join?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Does sql view stored data?
What is sql basics?
Why does sql need a server?
Which is faster truncate or drop?
What is a temporal table?
What is the difference between jpql and sql?
How to find 3rd highest salary of an employee from the employee table in sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Does mysql support pl sql?
How to select 10 records from a table?
Does pl/sql support create command?
Do we need to rebuild index after truncate?