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
- 10381 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 |
Can you tell me how to add new column in existing views?how?How is possible?
How many memory layers are in the oracle shared pool?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is Read-Only Transaction ?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain overloading. Can functions be overloaded?
How to drop an existing table in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
Difference between cartesian join and cross join?
Write a simple Store procedure and pass parameter to it ?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Oracle General 
