Re: Timezone information - Mailing list pgsql-general

From Dev Kumkar
Subject Re: Timezone information
Date
Msg-id CALSLE1NLvH6q5vpSX0iabbJ7N+NHsG9fKdM0n-yJTodCrDr=-g@mail.gmail.com
Whole thread Raw
In response to Re: Timezone information  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Timezone information  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Timezone information  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Thu, Feb 20, 2014 at 3:26 AM, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
On Thu, Feb 20, 2014 at 03:22:15AM +0530, Dev Kumkar wrote:
>
> Hmm. Missed one observation here, created a test table with timestamp
> column of type 'default current_timestamp'.
> When the query is executed from JDBC then it stores OS specific local time
> into this column.

Probably the JDBC driver is setting its TimeZone.  Really, try it:

SET TimeZone="UTC";
SELECT now();

SET TimeZone="EST5EDT";
SELECT now();

and so on.  Try selecting from your table, too, and you will discover
that the time zone of the timestamps changes.  If you're used to
certain other RDBMSes, this mode of functioning will be unusual, but
that really is how it works.

Yes had tried this earlier and it works as expected.

I think I missed that observation earlier and then was looking to set timezone in postgreSQL.conf which could ultimately resolve this.
But better is to set the TimeZone. Now haven't done anything special but JDBC is working with setting TimeZone and ODBC not. So what should I look from here now?

Regards...

pgsql-general by date:

Previous
From: Dev Kumkar
Date:
Subject: Re: UTF-8 collation on Windows?
Next
From: Andrew Sullivan
Date:
Subject: Re: Timezone information