1* select to_char(to_date('22/05/2008','dd/mm/yyyy'),&

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 / prabhu

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

Answer Posted / prabhu

1* select
to_char(to_date('22/05/2008','dd/mm/yyyy'),'mm/dd/yyyy')
from dual
SQL> /

TO_CHAR(TO
----------
05/22/2008

Is This Answer Correct ?

21 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3246

How to convert a string to a date in oracle database?

1100

How do I uninstall oracle 11g?

1176

How to apply filtering criteria at group level in oracle?

1084

What is meant by raw datatype?

1118

How to convert times to characters in oracle?

1071

How to bring a tablespace online?

1143

What is bulk collect in oracle?

1053

How do I find my oracle client driver version?

1095

How to fetch the row which has the max value for a column?

1044

How to use like conditions in oracle?

1115

What is the string concatenation operator in oracle?

1230

Â How to use an oracle sequence generator in a mapping?

1131

What is null value in oracle?

1158

Difference between pre-select and pre-query

1174