again convert in back to date using to

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

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

Answer Posted / pinki

again convert in back to date using to_date

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is blob data type in oracle?

1119

How many categories of data types?

994

Will you be able to store pictures in the database?explain.

992

Explain an integrity constrains?

1147

How to use "while" statements in oracle?

1325

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2272

What are data pump export and import modes?

1065

How to set a transaction to be read only in oracle?

1093

What are the types of trigger in oracle?

979

What is merge in oracle?

1054

What is the difference between post-database commit and post-form commit?

1195

What is the exact use of Collections?

2143

What are the attributes of the cursor?

1002

What is the use of aggregate functions in oracle?

1026

Difference between varchar and varchar2 data types?

1184