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
10392 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 are the ansi data types supported in oracle?

947

How does oracle handle read consistency?

1100

Where do you use decode and case statements?

996

How to see free space of each tablespace?

1036

How to count duplicated values in a column in oracle?

1046

Point the difference between translate and replace?

1095

Can a formula column referred to columns in higher group ?

2506

How do I start tns listener?

1047

What is data file?

1110

How to start instance with a minimal initialization parameter file?

1045

What happens if variable names collide with table/column names?

1193

State any two functions of oracle?

1046

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5412

How to rename an existing table?

1129

Use of an integrity constraint is better to validate data. Explain

1043