Re: date format mask?

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Fri, 10 Jun 2011 09:42:47 -0300
Message-ID: <BANLkTi=5k=VC+9bYJ4Y_0UrU1+qYJv_z7A_at_mail.gmail.com>

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
>>>
>>>
>>>
>>
>>
>

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

Received on Fri Jun 10 2011 - 07:42:47 CDT