How to convert the date format from dd/mm/yyyy to
mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008.
when u use to_char(), it tells the month is invalid. how to
resolve this problem.tel with eg.
Answer Posted / pinki
again convert in back to date using to_date
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What happens to the current transaction if the session is ended?
What are the uses of a database trigger?
How to create id with auto_increment on oracle?
Explain the use of Merge statement in oracle 11g
What is the difference between a primary key & a unique key?
How to convert csv to table in oracle?
Calculate difference between 2 date / times in oracle sql?
How to rename an index in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Explain what are synonyms used for?
List the parts of a database trigger.
Point the difference between translate and replace?
What is system global area (sga) in oracle?
What do you mean by merge in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?