Horton
Menu

Re: timestamp/date bug

Karel Zak <zakkr@zf.jcu.cz>

View thread
From: Karel Zak <zakkr@zf.jcu.cz>
To: Juan Flynn <juan@netsoc.tcd.ie>
Cc: pgsql-bugs@postgresql.org
Date: 2001-02-05T16:22:26Z
Lists: pgsql-bugs 
On Sun, 4 Feb 2001, Juan Flynn wrote:

> I've come across an odd bug in Postgres 7 (7.0.3 I think) that's probably
> best explained with an example:

> SELECT to_char(timestamp '23-Mar-2000' + 3, 'Mon DD');
>  to_char
> ---------
>  Mar 25
> (1 row)


in 7.1:

test=# SELECT to_char(timestamp '23-Mar-2000' + 3, 'Mon DD');
 to_char
---------
 Mar 26
(1 row)

test=# select timestamp '23-Mar-2000' + 3;
  ?column?
------------
 2000-03-26
(1 row)


 It's probably already fixed bug with timezones and "magic" dates :-)

			Karel