1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

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

Point out the difference between user tables and data dictionary?

538

What is the data pump import utility?

577

How to use windows user to connect to the server?

530

What is a snapshot in oracle database?

567

What is the usage of analyze command in oracle?

609




Explain implicit cursor.

553

how to make an oracle object

1854

What is using clause and give example?

579

Where is the export dump file located?

567

What is SQL Tuning Advisor in Oracle?

631

What is oracle database 10g express edition?

593

what is IDE,DMV in sql server?

2242

What is the exact use of Collections?

1677

How can I see all tables in oracle?

538

what are steps for interface? where is exchange rate defined in which table?

1493