Would an acceptable workaround for you to change the Java default timezone.
Either start the JVM with -Duser.timezone=GMT
or to invoke in your startup code TimeZone.setDefault(TimeZone.get("GMT"));
-Mikko
From: pgsql-jdbc-owner@postgresql.org <pgsql-jdbc-owner@postgresql.org> on behalf of Dave Cramer <pg@fastcrypt.com>
Sent: 13 November 2014 16:27
To: George Woodring
Cc: List
Subject: Re: [JDBC] Anyway to tell jdbc to use server timezone?
Ah, OK, this was done for binary protocol. I seem to recall this is somewhat defined in the spec according to setTimestamp.
Is there a reason why you can't just override this in your code when you get a connection ?