Re: date format mask?

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 10 Jun 2011 14:32:42 +0100
Message-ID: <BANLkTimzziux4-d3qUYTq_0w+5n7buo7jw_at_mail.gmail.com>

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_at_gmail.com>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_at_yahoo.com>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_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 <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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 10 2011 - 08:32:42 CDT