Postgres Pro
Downloads
Home   >   mailing lists

Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions - Mailing list pgsql-general

From John R Pierce
Subject Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions
Date
Msg-id 54000C6E.3050203@hogranch.com
Whole thread Raw
In response to Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions  (Vinayak <vinpokale@gmail.com>)
List pgsql-general
Tree view 
On 8/28/2014 10:06 PM, Vinayak wrote:
> Any idea how can we set OS timezone on PostgreSQL?

timestamp with time zone values are stored as the equivalent of UTC and
converted to the client TIME_ZONE setting for display, unless you
specify some other timezone via AT TIME ZONE

I'm not sure why any other behavior would be rational.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Vinayak
Date:
Subject: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions
Next
From: Albe Laurenz
Date:
Subject: Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions