Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 10320 Views
- AppLabs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
what is candidate key & super key
what is the difference between data migration and production migration.
How would you extract DDL of a table without using a GUI tool?
difference between procedures and function?
How to retrieve data from an explicit cursor?
What is the difference between hot backup and cold backup in oracle?
What is the difference between formal parameters and actual parameters?
What are the differences between primary key and unique key?
What are the differences between char and varchar2 in oracle?
What is the difference between postgresql and oracle?
when i run my query on yesterday it is fast but today it is slow why?
How would you design a database for an e-commerce website?
Oracle General 
