Skip site navigation (1) Skip section navigation (2)

Re: BUG #1630: Wrong conversion in to_date() function. See example.

From: Shelby Cain <alyandon(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: "Ariel E(dot) Carn/Elizabeth Sosa" <acarna(at)tarifar(dot)com>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Fuhr <mike(at)fuhr(dot)org>
Subject: Re: BUG #1630: Wrong conversion in to_date() function. See example.
Date: 2005-04-27 15:14:44
Message-ID: 20050427151444.1686.qmail@web50102.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-bugs
> 
> However we consider that to_date() exists to be
> Oracle compatible,
> and so I would regard this as a bug if and only if
> Oracle does
> something different with the same input.  Anyone
> know?
> 

Here is the output I get from Oracle:
=====================================================

Connected to:
Oracle8 Enterprise Edition Release 8.0.6.3.0 -
Production

SELECT to_date('2005-02-27', 'YYYY-MM-DD') from dual
TO_DATE('2005-02-27','YYYY-MM-
------------------------------
2/27/2005                     
1 row selected
 
SELECT to_date('2005-02-29', 'YYYY-MM-DD') from dual
ORA-01839: date not valid for month specified

SELECT to_date('2005-02-32', 'YYYY-MM-DD') from dual;
ORA-01847: day of month must be between 1 and last day
of month

===========================================

Regards,

Shelby Cain

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

pgsql-bugs by date

Next:From: Mike G.Date: 2005-04-27 15:39:53
Subject: Re: BUG #1629: subquery IN returns incorrect results
Previous:From: Sokolov YuraDate: 2005-04-27 15:07:22
Subject: BUG 1614 and BUG 1616 : Inadequate GIST Behaviour

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group