We do. ISO8601 http://en.wikipedia.org/wiki/ISO_8601#UTC - Amazon is using it, and recording the output in UTC. :) - Now it might be nice for Oracle to implement a named format parameter for to_date eg to_date('2011-05-24T23:21:30.000Z','ISO8601_LONG') On Fri, Jun 10, 2011 at 1:42 PM, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>wrote: > May I just say DATES SUCK? or at least everyone's implementations of dates > being different sucks... why can't we have a nice standard about? > > anyway, just needed to vent. > Alan.- > > > > On Fri, Jun 10, 2011 at 1:35 AM, David Fitzjarrell <oratune@xxxxxxxxx>wrote: > >> 'YYYY-MM-DD"T"HH24:MI:SS.FFF' >> >> is still an invalid format string. In timestamps the format would be >> >> 'YYYY-MM-DD HH24:MI:SSxFF TZH:TZM' >> >> But that still won't work; Wolfgang Breitling provided the simplest of >> solution as compared to my convoluted attempt at confusion. :D >> >> >> >> David Fitzjarrell >> >> >> >> ------------------------------ >> *From:* Gus Spier <gus.spier@xxxxxxxxx> >> *To:* eugene.pipko@xxxxxxxxxxxx >> *Cc:* "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> >> *Sent:* Thu, June 9, 2011 5:12:12 PM >> >> *Subject:* Re: date format mask? >> >> Ooops! I should have checked: that format string should be >> 'YYYY-MM-DD"T"HH24:MI:SS.FFF' >> >> Sorry, >> >> Gus >> >> On Thu, Jun 9, 2011 at 8:06 PM, Gus Spier <gus.spier@xxxxxxxxx> wrote: >> >>> 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 <http://amazon.com/> and >>>> wonder if it can be processed in Oracle? >>>> >>>> >>>> >>>> <LastUpdateDate>2011-05-24T23:21:30.000Z</LastUpdateDate> >>>> >>>> >>>> >>>> Thanks, >>>> >>>> Eugene >>>> >>>> >>>> >>> >>> >> > -- Niall Litchfield Oracle DBA http://www.orawin.info