Re: date format mask?

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 9 Jun 2011 19:20:17 -0600
Message-Id: <50991C47-0FA7-4CAC-A343-649FC402AA1C_at_centrexcc.com>

Not quite:

ora1025.scott> select to_date('2011-05-24T23:21:30.000Z','YYYY-MM-DD"T"HH24:MI:SS.FFF') from dual; select to_date('2011-05-24T23:21:30.000Z','YYYY-MM-DD"T"HH24:MI:SS.FFF') from dual

                                          *

ERROR at line 1:
ORA-01821: date format not recognized

On 2011-06-09, at 6:12 PM, Gus Spier wrote:

> Ooops! I should have checked: that format string should be 'YYYY-MM-DD"T"HH24:MI:SS.FFF'

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

Received on Thu Jun 09 2011 - 20:20:17 CDT