Re: date format mask?
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: gus.spier@xxxxxxxxx, eugene.pipko@xxxxxxxxxxxx
- Date: Thu, 9 Jun 2011 21:35:17 -0700 (PDT)
'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 and wonder if it can be
>>processed
>>in Oracle?
>>
>><LastUpdateDate>2011-05-24T23:21:30.000Z</LastUpdateDate>
>>
>>Thanks,
>>Eugene
>>
>
Other related posts:
