Re: SQL solution for my JDBC timezone issue

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: SQL solution for my JDBC timezone issue
Дата
Msg-id CADK3HH+xtCZytt-6o=AizVVwqCZQJfnnat0v0HLeB0xE2-Aqjw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQL solution for my JDBC timezone issue  (George Woodring <george.woodring@iglass.net>)
Список pgsql-general
Дерево обсуждения
George,


One solution for you might be to write a C function which gets the OS timezone and then you can execute set timezone=server_timezone();



Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 24 February 2015 at 09:25, George Woodring <george.woodring@iglass.net> wrote:
 -- In your original post you mentioned that access to the databases is through a Web server.

 -- Is there just one Web server with one time zone?

We have 2 web servers that are clustered together.  They are both set to Eastern since that is the timezone they are located in.

iGLASS Networks
www.iglass.net



В списке pgsql-general по дате отправления:

Предыдущее
От: George Woodring
Дата:
Сообщение: Re: SQL solution for my JDBC timezone issue
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Sequences not moved to new tablespace