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
          


Reply via email to