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
- 10328 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 |
How do I know if oracle client is installed on windows?
how to unbreak sequence numbers during intereptions
How to write a left outer join with the where clause in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What are the advantages of oracle?
how to retrieve daily sal from emp table in oracle 10g
How do I reset a sequence in oracle?
Explain the dml?
What is the difference between count (*), count (expression), count (distinct expression)?
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is trigger associated with the timer ?
Explain the use of full option in exp command.
Oracle General 
