Re: date format mask?
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Thu, 9 Jun 2011 21:35:17 -0700 (PDT)
Message-ID: <619010.29530.qm_at_web65415.mail.ac4.yahoo.com>
Date: Thu, 9 Jun 2011 21:35:17 -0700 (PDT)
Message-ID: <619010.29530.qm_at_web65415.mail.ac4.yahoo.com>
'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_at_gmail.com> To: eugene.pipko_at_unionbay.com Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 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_at_gmail.com> 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_at_unionbay.com> 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 >> >
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 09 2011 - 23:35:17 CDT