How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2

Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

Question Posted / abimalliga

2 Answers
10302 Views
AppLabs, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. ..

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 to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. ..

Answer / pinki

again convert in back to date using to_date

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What is connection pool in oracle?

How to define an anonymous block?

Is java required for oracle client?

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

0 Answers iFlex,

How to estimate disk space needed for an export job?

What do you mean by a deadlock?

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

Which database is better for os platform dependency?

how to make an oracle object

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

How can we Update a table with out using UPDATE command?

What is an oracle user role?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)