<div class="WordSection1"><p class="MsoNormal">I’ve created a user with a time zone of America/Chicago and a server
timezone 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.<p class="MsoNormal"> <p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"CourierNew";color:red">select now(), extract(timezone FROM now()),
current_setting('TIMEZONE'),now()-interval '1 hour' as "1HourAgo"</span><span style="color:red"></span><p
class="MsoNormal"> <pclass="MsoNormal">I don’t see any documented PostgreSQL JDBC connection properties that cause the
usertime zone to be honored. Is there a way to via a JDBC connection to cause the user time zone to be used? <p
class="MsoNormal"> <pclass="MsoNormal">Thanks in advance,<p class="MsoNormal"> <p class="MsoNormal">Clifton Sothoron<p
class="MsoNormal">SeniorProgrammer<p class="MsoNormal">Logi Analytics Inc.<p class="MsoNormal"> </div>
