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.
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
What is blob data type in oracle?
How many categories of data types?
Will you be able to store pictures in the database?explain.
Explain an integrity constrains?
How to use "while" statements in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are data pump export and import modes?
How to set a transaction to be read only in oracle?
What are the types of trigger in oracle?
What is merge in oracle?
What is the difference between post-database commit and post-form commit?
What is the exact use of Collections?
What are the attributes of the cursor?
What is the use of aggregate functions in oracle?
Difference between varchar and varchar2 data types?