User time zone ignored in JDBC/PostgreSql
От | Clifton B. Sothoron Jr. |
---|---|
Тема | User time zone ignored in JDBC/PostgreSql |
Дата | |
Msg-id | 6A395F497CE89A4693420F1134B3FDB896E4504D@LogiMail10.LogiXML.local обсуждение исходный текст |
Ответы |
Re: User time zone ignored in JDBC/PostgreSql
|
Список | pgsql-interfaces |
<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>
В списке pgsql-interfaces по дате отправления: