Обсуждение: TIMESTAMP and daylight savings time question
<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>
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?