Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL solution for my JDBC timezone issue - Mailing list pgsql-general

From Dave Cramer
Subject Re: SQL solution for my JDBC timezone issue
Date
Msg-id CADK3HH+xtCZytt-6o=AizVVwqCZQJfnnat0v0HLeB0xE2-Aqjw@mail.gmail.com
Whole thread Raw
In response to Re: SQL solution for my JDBC timezone issue  (George Woodring <george.woodring@iglass.net>)
List pgsql-general
Tree view
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 by date:

Previous
From: George Woodring
Date:
Subject: Re: SQL solution for my JDBC timezone issue
Next
From: Adrian Klaver
Date:
Subject: Re: Sequences not moved to new tablespace