Re: Bug in JDBC-Driver? - Mailing list pgsql-jdbc

From John R Pierce
Subject Re: Bug in JDBC-Driver?
Date
Msg-id 41C3E16F.1050403@hogranch.com
Whole thread Raw
In response to Re: Bug in JDBC-Driver?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bug in JDBC-Driver?  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
> The really serious problem with this is the assumption that the server
> has the same set of available timezones (and spellings of same) as the
> client does.

timezones seriously suck.

China uses CST. So does North America.     How you gonna resolve THAT ?

The proper solution is to use "ISO" time with -07 / +08 kinda timezones if you
need to get data in/out of timestampz fields....  Java can do this just by
specifying the right option when you convert a calendar time to a string.

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Bug in JDBC-Driver?
Next
From: Kris Jurka
Date:
Subject: Re: Bug in JDBC-Driver?