Re: Time conversion across various parts of world

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: deepthi(at)granwill(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Time conversion across various parts of world
Date: 2004-11-26 18:17:26
Message-ID: 10152.1101493046@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

John R Pierce <pierce(at)hogranch(dot)com> writes:
> deepthi(at)granwill(dot)com wrote:
>> How can i convert this time or get the corresponding
>> time at US using pgsql time zone feature or if anything else.

> store GMT in the database always, convert back to local time when you
> display it.

Note that the TIMESTAMP WITH TIME ZONE datatype effectively does that
for you. The only thing you need to do is SET TIMEZONE to the
appropriate timezone for data entry or display. The server's timezone
is really entirely irrelevant, except that it sets the initial default
value for the TIMEZONE setting.

regards, tom lane

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Manuel Sugawara 2004-11-26 19:33:29 Re: Result set not positioned properly, perhaps you need to
Previous Message John R Pierce 2004-11-26 07:12:15 Re: Time conversion across various parts of world