Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help to Convert Arabic Date to English Date format

3300946Jan 25 2017 — edited Jan 25 2017

Hello Gurus,

I have table with field column DOB(which is varchar2) which in arabic language , I need to convert to english format DD-MON-YYYY HH24:MI:SS I tried several approaches but couldn't able to get any breakthrough.

Request you to kindly help

select to_date('الأحد يناير ١٤ ٠٠:٠٠:٠٠ ١٩٩٠','DD MON DY HH:MI:SS YYYY','NLS_DATE_LANGUAGE=ENGLISH')

from dual

Regards,

Achyut

Message was edited by: 3300946

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2017
Added on Jan 25 2017
7 comments
1,958 views