Bug with Daylight Savings Time & Interval
От | Josh Berkus |
---|---|
Тема | Bug with Daylight Savings Time & Interval |
Дата | |
Msg-id | 200205201534.32937.josh@agliodbs.com обсуждение исходный текст |
Ответы |
Re: [SQL] Bug with Daylight Savings Time & Interval
|
Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: