Juan Flynn wrote:
> SELECT to_char(timestamp '23-Mar-2000' + 3, 'Mon DD');
> to_char
> -
> Mar 25
> (1 row)
>
> Which is wrong, however:
Dates are interpreted "at a special time" (midnight).
Mar 25 is most likely a daylightsaving day for your timezone.
Just add some hours to the resu
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-
[EMAIL PROTECTED] (Juan Flynn) writes:
> This odd date bug seems to skip over March 26 2000, and it occurs also
> on March 25 2001 and March 30 2002.
Would those happen to be daylight-savings-time transition dates in your
timezone? If so, this is a known bug; it's fixed for 7.1.
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' + 1, 'Mon DD');
to_char
-
Mar 24
(1 row)
Which is correct.
SELECT to_char(timestamp '23-Mar-2000' + 2, 'Mon DD');
to_char
-
Mar 25
