Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!news.swapon.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: "M. Strobel" <sorry_no_mail_here@nowhere.dee>
Newsgroups: comp.databases.postgresql
Subject: Re: timestamp and time zone
Date: Thu, 28 Apr 2011 19:22:12 +0200
Lines: 30
Message-ID: <91tm24Fqi2U1@mid.uni-berlin.de>
References: <91th8nFmufU1@mid.uni-berlin.de> <5267e2fa-1027-4a69-8829-1d8a60aa89ab@e21g2000vbz.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de 3Heq36fyy77NzpiOyJB9egqpnVsS5w5kKdmwb5q2FTdG8qjBw=
User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); de; rv:1.9.2.12) Gecko/20101027 Lightning/1.0b2 Thunderbird/3.1.6
In-Reply-To: <5267e2fa-1027-4a69-8829-1d8a60aa89ab@e21g2000vbz.googlegroups.com>
Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:97

Am 28.04.2011 19:05, schrieb Dog is love:
> On 28 Apr., 18:00, "M. Strobel" <sorry_no_mail_h...@nowhere.dee>
> wrote:
>> Hi,
>>
>> I did not quite understand the use case of timestamp with time zone.
>>
>> When do you need 'with time zone'? My tests show you can
>> calculate other time zones time easily from a timestamp without
>> time zone.
>>
>> Is timestamp internally stored normalized to utc, and calculated
>> to client time zone? Or to server time zone?
>>
>> Suppose a linux server with system clock set to utc.
>>
>> thanks for the light you will certainly shed on this...
>>
>> /Str.
> 
> some light...
> 
> http://en.wikipedia.org/wiki/Tz_database

I've seen this light before.

The question is rather: how is timestamp stored? If it is
normalized to utc then what is the use of time zone?

/Str.