Postgres Pro
Downloads
Home   >   mailing lists

Re: Timezone information - Mailing list pgsql-general

From Dev Kumkar
Subject Re: Timezone information
Date
Msg-id CALSLE1MDCohAeu6-WN_grn_eJHakjOXeuArU0Fb-FBv2OTj5mw@mail.gmail.com
Whole thread Raw
In response to Re: Timezone information  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Timezone information  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Thu, Feb 20, 2014 at 3:53 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
Each driver will have its own behavior. For an explanation of the JDBC behavior see here:

http://www.postgresql.org/message-id/4B2F2CED.10400@opencloud.com


Per Andrews posts, the least surprise behavior is to explicitly set the client time zone. Then you control what is being seen/used.

Actually then this goes back to the same thing that identify the timezone setting in OS and accordingly set at the driver level.
In case of java JVM is picking up OS timezone and hence things are working without any issues for windows/linux both.

Regards...

pgsql-general by date:

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