Request a Demo
Home   >   mailing lists

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

From Clifton B. Sothoron Jr.
Subject User time zone ignored in JDBC/PostgreSql
Date
Msg-id 6A395F497CE89A4693420F1134B3FDB896E4504D@LogiMail10.LogiXML.local
Whole thread Raw
Responses Re: User time zone ignored in JDBC/PostgreSql
List pgsql-interfaces
Tree view

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: "Attila Peller"
Date:
Subject: cursor updatability changed
Next
From: Dave Cramer
Date:
Subject: Re: User time zone ignored in JDBC/PostgreSql