8.1.x (tested 8.1.8) timezone bugs
От | Joshua D. Drake |
---|---|
Тема | 8.1.x (tested 8.1.8) timezone bugs |
Дата | |
Msg-id | 45F6E295.1010507@commandprompt.com обсуждение исходный текст |
Ответы |
Re: 8.1.x (tested 8.1.8) timezone bugs
Re: 8.1.x (tested 8.1.8) timezone bugs |
Список | pgsql-hackers |
Hello, When updating for DST we found this nifty problem. This does not happen on 8.2. postgres=# SET TIMEZONE TO 'PST8PDT'; SET postgres=# select now(); now -------------------------------2007-03-13 10:41:07.034754-07 (1 row) postgres=# SET TIMEZONE TO PST8PDT; SET postgres=# SELECT NOW(); now -------------------------------2007-03-13 09:41:07.036069-08 (1 row) postgres=# set time zone PST8PDT; SET postgres=# select now(); now -------------------------------2007-03-13 09:41:07.038045-08 (1 row) postgres=# SET TIME ZONE 'PST8PDT'; SET postgres=# select now(); now -------------------------------2007-03-13 10:41:07.039145-07 (1 row) -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
В списке pgsql-hackers по дате отправления: