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
- 10298 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 privilege is needed for a user to query tables in another schema?
How to open a cursor variable?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
What are the system predefined user roles?
What are the differences between primary key and unique key?
Why we choose emp number as primarykey?
What is the implicit cursor in oracle?
how do u setup a replication site?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the difference between post-database commit and post-form commit?
What is the purpose of save points in oracle database?
What are the different editions of oracle?
Oracle General 
