Link to home
Start Free TrialLog in
Avatar of angel7170
angel7170Flag for United States of America

asked on

Convert XML Gregorian Date to Oracle Date format

Hello,

I have an XML file where the date is stored in Gregorian date format as below
    <pxUpdateDateTime>2012-08-12T22:08:45.274Z</pxUpdateDateTime>

How to convert this date into oracle date format MM/DD/YYYY HH:MM:SS?

Please assist.

Thank you
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PortletPaul
PortletPaul
Flag of Australia image
the "oracle date format"?

Oracle does NOT store dates or timestamps "in a format" (they are stored as sets of integers)

Humans need "formats" for dates, not the dbms, and what we see is controlled by nls_date_format

e.g.
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;

alter session set nls_date_format='mm-dd-yyyy hh24:mi:ss';
select sysdate from dual;