Re: SQL solution for my JDBC timezone issue

Yes, that is where we think we are heading, the issue is that the code does not know what it needs to be set back to.  We have 90 databases with 5 different time zones.  I was just hoping for a more elegant solution than writing a lookup table that says if you are connecting to db x then set to timezone y.

George Woodring 

iGLASS Networks
www.iglass.net

On Mon, Feb 23, 2015 at 9:16 AM, Dave Cramer <pg@fastcrypt.com> wrote:

Well you could always just put it back to whatever you want when you open the connection  ie "set timezone ...."

 

Dave Cramer

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

On 23 February 2015 at 08:40, George Woodring <george.woodring@iglass.net> wrote:

Anyone have a suggestion for setting the timezone back to the Postgres db default on a connection.  JDBC now sets the timezone to be the client which is my web server and ignores the default timezone that I have set in the DB.  There are large parts of my code that I have never worried about timezones because the DB would handle it.  Before I head down that path, I thought I would check and see if there was an easier way for me to put it back into the database.

My latest issue is I create a date object and set it to 3am PST,  If I save it into a timestamp with timezone the db saves it at 3am PST when I pull it out.  If I save it to timestamp without timezone, I get 6am now where as before I would get 3am.

Any suggestions would be appreciated

George Woodring

iGLASS Networks
www.iglass.net