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