Re: TimeZone related issues in org.postgresql.jdbc2.TimestampUtils - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: TimeZone related issues in org.postgresql.jdbc2.TimestampUtils
Date
Msg-id 4AAD7EB7.7020806@opencloud.com
Whole thread Raw
In response to TimeZone related issues in org.postgresql.jdbc2.TimestampUtils  ("Carsten Klein" <carsten.klein@axn-software.de>)
Responses Re: TimeZone related issues in org.postgresql.jdbc2.TimestampUtils  ("Carsten Klein (tarent)" <carsten.klein@axn-software.de>)
List pgsql-jdbc
Carsten Klein wrote:
> Hi All,
>
> in an application that uses TIMESTAMP WITH TIME ZONE as the type for
> certain attributes, we stumbled across the problem that, sometimes, the
> values returned from the database will be adjusted so that the time zone
> offset will be added/subtracted from the actual time stored in the
> database.

Timezone stuff is very picky. Can you provide a standalone testcase so
we can see exactly what's going on?

-O

pgsql-jdbc by date:

Previous
From: "Carsten Klein"
Date:
Subject: TimeZone related issues in org.postgresql.jdbc2.TimestampUtils
Next
From: Manoj Ganesan
Date:
Subject: Inconsistency between timezones