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

What is meant by joins?

1058

How to call a sub procedure?

1093

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2157

What is BBED in Oracle?

1150

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

948

defination of bitmap index

2117

What is a Garbage Collection? and what is full recursive Garbage collection?

2898

How to drop a stored function?

1135

How do I uninstall oracle 11g?

1115

How to filter out duplications in the returning rows using oracle?

1015

What is snapshot is too old? Give and example for better understand.

1601

What do you mean by a database transaction & what all tcl statements are available in oracle?

992

How many types of tables are there in oracle?

1059

How to bring a tablespace online?

1073

Why do we use coalesce function in oracle?

1112