Re: date format mask?

Not quite:

SQL> variable l_amazon_date varchar2(40)
SQL>
SQL> begin
  2     :l_amazon_date := '2011-05-24T23:21:30.000Z';
  3  end;
  4  /
PL/SQL procedure successfully completed.
SQL>
SQL> select TO_DATE(:l_amazon_date, 'YYYY-MM-DDTHH24:MI:SS.FFF')
  2  from dual;
select TO_DATE(:l_amazon_date, 'YYYY-MM-DDTHH24:MI:SS.FFF')
                               *
ERROR at line 1:
ORA-01821: date format not recognized

SQL>

This does:

SQL> variable l_amazon_date varchar2(40)
SQL>
SQL> begin
  2     :l_amazon_date := substr(translate('2011-05-24T23:21:30.000Z', 'TZ',' 
'),1, instr(translate('2011-05-24T23:21:30.000Z', 'TZ',' '),'.') - 1);
  3  end;
  4  /
PL/SQL procedure successfully completed.
SQL>
SQL> select TO_DATE(:l_amazon_date, 'YYYY-MM-DD HH24:MI:SS')
  2  from dual;
TO_DATE(:
---------
24-MAY-11
SQL>

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:06:29 PM
Subject: Re: date format mask?

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