Will TO_DATE() not work? TO_DATE(l_amazon_date, 'YYYY-MM-DDTHH24:MI:SS.FFF') r, Gus On Thu, Jun 9, 2011 at 5:58 PM, Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>wrote: > Hi all, > > I am getting this value back from Amazon.com and wonder if it can be > processed in Oracle? > > > > <LastUpdateDate>2011-05-24T23:21:30.000Z</LastUpdateDate> > > > > Thanks, > > Eugene > > >