again convert in back to date using to

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.

Question Posted / pinki

2 Answers
10299 Views
AppLabs, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What happens to the current transaction if the session is ended?

1033

What are the uses of a database trigger?

926

How to create id with auto_increment on oracle?

932

Explain the use of Merge statement in oracle 11g

975

What is the difference between a primary key & a unique key?

1037

How to convert csv to table in oracle?

921

Calculate difference between 2 date / times in oracle sql?

985

How to rename an index in oracle?

1059

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

947

Explain what are synonyms used for?

980

List the parts of a database trigger.

988

Point the difference between translate and replace?

1025

What is system global area (sga) in oracle?

927

What do you mean by merge in oracle?

937

In the oracle version 9.3.0.5.0, what does each number shows?

1223