Postgres Pro
Downloads
Home   >   mailing lists

Re: Anyway to tell jdbc to use server timezone? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Anyway to tell jdbc to use server timezone?
Date
Msg-id CADK3HHJN56OobVDGWrO=rw248-rqw2r6Et1rBxxM=Ahe3NtYOg@mail.gmail.com
Whole thread Raw
In response to Anyway to tell jdbc to use server timezone?  (George Woodring <george.woodring@iglass.net>)
Responses Re: Anyway to tell jdbc to use server timezone?  (George Woodring <george.woodring@iglass.net>)
List pgsql-jdbc
Tree view
George,

I looked at the stackoverflow example. I fail to see how the driver would change the where clause.

Can you create a self contained test case ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 12 November 2014 13:48, George Woodring <george.woodring@iglass.net> wrote:
I originally asked a question about adjusting timezone per db back


And it was suggested that I set them per db, which I have.  But now moving to 
9.3 of the jdbc driver, it seems to set the timezone to the web server's timezone.

I have found mentions


and


My question here is is there a way to disable it and get the older functionality?  Is there a command I could run after I get the connection to say "set timezone = 'server default'"?

Thanks
George Woodring
iGLASS Networks
www.iglass.net

pgsql-jdbc by date:

Previous
From: Marko Topolnik
Date:
Subject: Re: New significance of holdable result sets in Java 8
Next
From: Kevin Wooten
Date:
Subject: Re: New significance of holdable result sets in Java 8