Re: [GENERAL] Time Zone Error

2007-05-17 Thread Magnus Hagander
Tom Lane wrote: > Richard Huxton <[EMAIL PROTECTED]> writes: >> Hang on - did the US not alter the daylight-saving date recently? I'll >> bet that's the issue. > > We're well past both the old and new change dates though, so for any > combination of OS and Postgres knowing/not knowing about the l

Re: [GENERAL] Time Zone Error

2007-05-17 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> writes: > Hang on - did the US not alter the daylight-saving date recently? I'll > bet that's the issue. We're well past both the old and new change dates though, so for any combination of OS and Postgres knowing/not knowing about the law change, they ought to b

Re: [GENERAL] Time Zone Error

2007-05-17 Thread Tom Lane
Jamie Deppeler <[EMAIL PROTECTED]> writes: > We currently running Windows 2003 issues with time zone set to > (GMT-05:00) Eastern Time (US & Canada). Problem that we currently have > with Postgresql 8.1.5 is that time zone is being reported with a > incorrect off set –4 not –5 and this is causin

Re: [GENERAL] Time Zone Error

2007-05-17 Thread Jamie Deppeler
Richard Huxton wrote: Jamie Deppeler wrote: Hi, We currently running Windows 2003 issues with time zone set to (GMT-05:00) Eastern Time (US & Canada). Problem that we currently have with Postgresql 8.1.5 is that time zone is being reported with a incorrect off set –4 not –5 and this is caus

Re: [GENERAL] Time Zone Error

2007-05-17 Thread Richard Huxton
Jamie Deppeler wrote: Richard Huxton wrote: Jamie Deppeler wrote: Hi, We currently running Windows 2003 issues with time zone set to (GMT-05:00) Eastern Time (US & Canada). Problem that we currently have with Postgresql 8.1.5 is that time zone is being reported with a incorrect off set –4

Re: [GENERAL] Time Zone Error

2007-05-17 Thread Richard Huxton
Jamie Deppeler wrote: Hi, We currently running Windows 2003 issues with time zone set to (GMT-05:00) Eastern Time (US & Canada). Problem that we currently have with Postgresql 8.1.5 is that time zone is being reported with a incorrect off set –4 not –5 and this is causing incorrect time to be

[GENERAL] Time Zone Error

2007-05-17 Thread Jamie Deppeler
Hi, We currently running Windows 2003 issues with time zone set to (GMT-05:00) Eastern Time (US & Canada). Problem that we currently have with Postgresql 8.1.5 is that time zone is being reported with a incorrect off set –4 not –5 and this is causing incorrect time to be set. Below is exampl