Re: date format mask?
- From: Gus Spier <gus.spier@xxxxxxxxx>
- To: eugene.pipko@xxxxxxxxxxxx
- Date: Thu, 9 Jun 2011 20:12:12 -0400
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:
