Postgres Pro
Downloads
Home   >   mailing lists

Re: User time zone ignored in JDBC/PostgreSql - Mailing list pgsql-interfaces

From Dave Cramer
Subject Re: User time zone ignored in JDBC/PostgreSql
Date
Msg-id CADK3HHK03Z9bGZNtUH6wcDQCyjU_KqcT-jSzU=kGpnCrka3dnA@mail.gmail.com
Whole thread Raw
In response to User time zone ignored in JDBC/PostgreSql  ("Clifton B. Sothoron Jr." <Clifton.SothoronJr@logianalytics.com>)
List pgsql-interfaces
Tree view
This is actually an artifact of the JDBC spec which at the moment eludes me, but IIRC the time defaults to the time of the server running the application; not the server.

AFAIK we don't even look at the user timezone. 

Not sure that helps




On 6 December 2016 at 10:50, Clifton B. Sothoron Jr. <Clifton.SothoronJr@logianalytics.com> wrote:

I’ve created a user with a time zone of America/Chicago and a server time zone of America/New York. I run the following query and America/New York is returned. The user time zone setting is ignored. It doesn’t seem to be usable via JDBC.

 

select now(), extract(timezone FROM now()), current_setting('TIMEZONE'), now()-interval '1 hour' as "1HourAgo"

 

I don’t see any documented PostgreSQL JDBC connection properties that cause the user time zone to be honored. Is there a way to via a JDBC connection to cause the user time zone to be used? 

 

Thanks in advance,

 

Clifton Sothoron

Senior Programmer

Logi Analytics Inc.

 


pgsql-interfaces by date:

Previous
From: "Clifton B. Sothoron Jr."
Date:
Subject: User time zone ignored in JDBC/PostgreSql
Next
From: Bob Nick
Date:
Subject: help with pgsql_perl5-1.9.0