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

Answer Posted / dinesh kumar

Invalid Character Error

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rtm stands for?

746


What are different types of queries in sql?

732


How do you update f as m and m as f from the below table testtable?

1465


How do I make my sql query run faster?

662


Why trigger is used in sql?

690






Is mariadb a nosql database?

760


Which table is left in left join?

715


What is embedded sql in db2?

708


how mysql optimizes distinct? : Sql dba

728


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

736


What are the different datatypes available in PL/SQL?

754


How to write a query to show the details of a student from students table whose

755


How do you rename a table in sql?

735


what is self-join? : Sql dba

756


How do I send sql query results to excel?

767