Обсуждение: TIMESTAMP and daylight savings time question

Поиск
Список
Период
Сортировка

TIMESTAMP and daylight savings time question

От
"Dann Corbit"
Дата:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">It appears that the older versions of PostgreSQL (7.x) do not consider the daylight savings time
whenusing TIMESTAMP WITH TIMEZONE but the most recent versions do (8.x).</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">Can someone tell me the exact PostgreSQL version number where the behavior changed?</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font></div>

Re: TIMESTAMP and daylight savings time question

От
"Dann Corbit"
Дата:
We figured the problem out.
Our older version did not have the OS patch:
http://www.postgresqlforums.com/wiki/2007_Daylight_Savings_Time

________________________________________
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Dann Corbit
Sent: Wednesday, March 12, 2008 6:06 PM
To: pgsql-hackers@postgresql.org
Cc: Larry McGhaw
Subject: [HACKERS] TIMESTAMP and daylight savings time question

It appears that the older versions of PostgreSQL (7.x) do not consider
the daylight savings time when using TIMESTAMP WITH TIMEZONE but the
most recent versions do (8.x).
Can someone tell me the exact PostgreSQL version number where the
behavior changed?