Re: timestamp/date bug - Mailing list pgsql-bugs

From Karel Zak
Subject Re: timestamp/date bug
Date
Msg-id Pine.LNX.3.96.1010205171935.29540G-100000@ara.zf.jcu.cz
Whole thread Raw
In response to timestamp/date bug  (juan@netsoc.tcd.ie (Juan Flynn))
List 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

pgsql-bugs by date:

Previous
From: Max Vaschenko
Date:
Subject: postmaster grows
Next
From: Nabil Sayegh
Date:
Subject: Re: timestamp/date bug