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