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: