From: Josh Berkus <josh@agliodbs.com>
To: pgsql-sql@postgresql.org
Cc: pgsql-bugs@postgresql.org
Subject: Bug with Daylight Savings Time & Interval
Date: Mon, 20 May 2002 15:34:32 -0700
Message-ID: <200205201534.32937.josh@agliodbs.com> (raw)
Folks,
Found this interesting bug:
jwnet=> select version();
version
---------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.3
(1 row)
jwnet=> select ('2001-07-31 10:00:00 PST'::TIMESTAMP) + ('248 days'::INTERVAL)
;
?column?
------------------------
2002-04-05 10:00:00-08
(1 row)
jwnet=> select ('2001-07-31 10:00:00 PST'::TIMESTAMP) + ('249 days'::INTERVAL)
;
?column?
------------------------
2002-04-06 10:00:00-08
(1 row)
jwnet=> select ('2001-07-31 10:00:00 PST'::TIMESTAMP) + ('250 days'::INTERVAL)
;
?column?
------------------------
2002-04-07 11:00:00-07
jwnet=> select ('2001-04-01 10:00:00 PST'::TIMESTAMP) + ('100 days'::INTERVAL)
;
?column?
------------------------
2001-07-10 11:00:00-07
It appears that Spring Daylight Savings Time causes PostgreSQL to change my
time zone. Only the spring, mind you, and not the fall. This is
potentially catastrophic for the application I'm developing; what can I do to
see that it's fixed? Or am I misunderstanding the behavior, here?
--
-Josh Berkus
P.S. I'm posting this here instead of the online bug form because I know that
Bruce is on vacation.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, pgsql-bugs@postgresql.org
Subject: Re: Bug with Daylight Savings Time & Interval
In-Reply-To: <200205201534.32937.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox