Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!feeder.news-service.com!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: Fri, 29 Apr 2011 12:23:13 +0200
Lines: 32
Message-ID: <91vhshFmsiU1@mid.uni-berlin.de>
References: <91th8nFmufU1@mid.uni-berlin.de> <91v543FpvnU1@mid.individual.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de nSJscV3wLezgUse4i1mUvwHqrd0Zxk9xPBvooETK4A4j73zfI=
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: <91v543FpvnU1@mid.individual.net>
Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:99

Am 29.04.2011 08:45, schrieb Harry Tuttle:
> M. Strobel, 28.04.2011 18:00:
>> 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?
> 
> From the manual at:
> 
> http://www.postgresql.org/docs/current/static/datatype-datetime.html#DATATYPE-TIMEZONES
> 
> 
> All timezone-aware dates and times are stored internally in UTC.
> They are converted to local time in the zone specified by the
> timezone configuration parameter before being displayed to the
> client.
> 
> 

And I can _not_ conclude from this that a date/time without
timezone is not stored in utc, right?

The server clock is set to utc.

So where does the difference show up?

/Str.