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: (view raw, whole thread or download thread mbox)
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 -

SELECT to_date('2005-02-27', 'YYYY-MM-DD') from dual
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



Shelby Cain

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

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-2017 The PostgreSQL Global Development Group