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

Where is the export dump file located?

1082

State the various uses of dbcc command?

992

How to create a new table in your schema?

1034

What is Library Cache in Oracle?

1077

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2190

When do we use group by clause in a sql query?

995

How to write date and time literals in oracle?

949

ABOUT IDENTITY?

2006

What is max rowid in oracle?

966

Can multiple cursors being opened at the same time?

1018

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2214

What is the difference between view and materialized view in Oracle?

1094

What is the sql query to concatenate column values from multiple rows in oracle?

999

How will you write a query to get a 5th rank student from a table student_report?

1815

how to handle exceptions in post production

1362