We figured the problem out. Our older version did not have the OS patch: http://www.postgresqlforums.com/wiki/2007_Daylight_Savings_Time
________________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers