Re: date format mask?
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: gus.spier@xxxxxxxxx
- Date: Thu, 9 Jun 2011 19:20:17 -0600
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'
Other related posts:
