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
10382 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

How do you find current date and time in oracle?

1045

What is the difference between pre-select and pre-query?

1211

What does sharding mean?

995

Name the various constraints used in oracle?

1015

State and explain the different types of data models?

938

How to write a query with an inner join in oracle?

1036

What is an oracle database?

1033

What do you mean by merge in oracle and how can you merge two tables?

948

What is a lookup table in oracle?

971

How to insert a record into a table?

1066

What happens to indexes if you drop a table?

1169

How to speed up webrick?

1071

Explain about achiever in sql?

1032

How to write a query with a left outer join in oracle?

1061

What is BBED in Oracle?

1150