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 |
What is Library Cache in Oracle?
How to declare a local variable?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
How to put more than 1000 values into an oracle in clause?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
What is backup in Oracle?
which sql command we can use to get a print out from oracle?
What is the maximum number of triggers that can be applied to a single table?
What a SELECT FOR UPDATE cursor represent.?
Give syntax for SQL and ORACLE joins.
What is sequence?
does the query needs a hint to access a materialized view?