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: timestamp and time zone
Date: Thu, 28 Apr 2011 18:00:23 +0200
Lines: 17
Message-ID: <91th8nFmufU1@mid.uni-berlin.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de xKOj+os9Z0dfLvMOZdKW3wKnITCtkpxApRl4dS8vezJBrSOAw=
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
Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:95

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.