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.
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 |
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
What are the differences between lov and list item?
what is index?
How to set up autotrace for a user account?
How to get a create statement for an existing table?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
Difference between hot backup vs. Cold backup?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to display employee records who gets more salary than the average salary in the department?
How different is ms access and oracle?
Why does oracle 9i treat an empty string as null?