Re: date format mask?
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: oratune@xxxxxxxxx
- Date: Fri, 10 Jun 2011 09:42:47 -0300
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
>>>
>>>
>>>
>>
>>
>
Other related posts:
