How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2

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

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

Answers were Sorted based on User's Feedback

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. ..

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

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. ..

Answer / pinki

again convert in back to date using to_date

Is This Answer Correct ?

5 Yes

0 No

Post New Answer