Re: Anyway to tell jdbc to use server timezone?

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(dot)woodring(at)iglass(dot)net>
wrote:

> I originally asked a question about adjusting timezone per db back
>
> 1B1B254441DB31448BD34C5BD73B0B8B2904B1(at)PHOENIX(dot)istructure(dot)com
> <http://www.postgresql.org/message-id/1B1B254441DB31448BD34C5BD73B0B8B2904B1@PHOENIX.istructure.com>
>
>
> 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
>
> CAAXGW-y==FOGGB7jVWhDsaugXV20qeXUcgZSiteQ7jfMXOKi-A(at)mail(dot)gmail(dot)com
> <http://www.postgresql.org/message-id/CAAXGW-y==FOGGB7jVWhDsaugXV20qeXUcgZSiteQ7jfMXOKi-A@mail.gmail.com>
>
>
> and
>
>
> http://stackoverflow.com/questions/18447995/postgresql-9-2-jdbc-driver-uses-client-time-zone
>
> 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
>