Groups > comp.databases.postgresql > #97

Re: timestamp and time zone

From	"M. Strobel" <sorry_no_mail_here@nowhere.dee>
Newsgroups	comp.databases.postgresql
Subject	Re: timestamp and time zone
Date	2011-04-28 19:22 +0200
Message-ID	<91tm24Fqi2U1@mid.uni-berlin.de> (permalink)
References	<91th8nFmufU1@mid.uni-berlin.de> <5267e2fa-1027-4a69-8829-1d8a60aa89ab@e21g2000vbz.googlegroups.com>

Show all headers | View raw

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.

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

timestamp and time zone "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-28 18:00 +0200
  Re: timestamp and time zone Dog is love <michaelnewportyahoo.com@gmail.com> - 2011-04-28 10:05 -0700
    Re: timestamp and time zone "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-28 19:22 +0200
  Re: timestamp and time zone Harry Tuttle <OTPXDAJCSJVU@spammotel.com> - 2011-04-29 08:45 +0200
    Re: timestamp and time zone "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-29 12:23 +0200
      Re: timestamp and time zone D Yuniskis <not.going.to.be@seen.com> - 2011-04-29 06:02 -0700
  Re: timestamp and time zone Jasen Betts <jasen@xnet.co.nz> - 2011-04-30 11:15 +0000
    Re: timestamp and time zone Jasen Betts <jasen@xnet.co.nz> - 2011-04-30 11:26 +0000
    Re: timestamp and time zone "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-30 17:58 +0200
      Re: timestamp and time zone Jasen Betts <jasen@xnet.co.nz> - 2011-05-01 11:33 +0000

csiph-web