Re: date format mask?

From: Gus Spier <gus.spier_at_gmail.com>
Date: Thu, 9 Jun 2011 20:12:12 -0400
Message-ID: <BANLkTiko8akOK4p9BU=M_6tB4AoVL34U-Q_at_mail.gmail.com>

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

Received on Thu Jun 09 2011 - 19:12:12 CDT