Re: User time zone ignored in JDBC/PostgreSql
| От | Dave Cramer |
|---|---|
| Тема | Re: User time zone ignored in JDBC/PostgreSql |
| Дата | |
| Msg-id | CADK3HHK03Z9bGZNtUH6wcDQCyjU_KqcT-jSzU=kGpnCrka3dnA@mail.gmail.com обсуждение исходный текст |
| Ответ на | User time zone ignored in JDBC/PostgreSql ("Clifton B. Sothoron Jr." <Clifton.SothoronJr@logianalytics.com>) |
| Список | pgsql-interfaces |
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 по дате отправления: