Path: csiph.com!x330-a1.tempe.blueboxinc.net!aioe.org!wieslauf.sub.de!.POSTED!reversiblemaps.ath.cx!not-for-mail
From: Jasen Betts <jasen@xnet.co.nz>
Newsgroups: comp.databases.postgresql
Subject: Re: timestamp and time zone
Date: 30 Apr 2011 11:26:48 GMT
Organization: Dis (not Dat) Organisation
Lines: 20
Message-ID: <ipgrlo$rf5$2@reversiblemaps.ath.cx>
References: <91th8nFmufU1@mid.uni-berlin.de> <ipgr0s$rf5$1@reversiblemaps.ath.cx>
NNTP-Posting-Host: Wk8PyTvLHfx9YaNov58aSw.user.wieslauf.sub.de
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@wieslauf.sub.de
NNTP-Posting-Date: Sat, 30 Apr 2011 11:30:38 +0000 (UTC)
User-Agent: slrn/pre1.0.0-18 (Linux)
X-Notice: Filtered by postfilter v. 0.8.1
X-Face: ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s;a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
Cancel-Lock: sha1:+Qo9cjjK+4A5dZ3OTbQ5BBlCV3I=
Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:103

On 2011-04-30, Jasen Betts <jasen@xnet.co.nz> wrote:

> timestamp is internally stored with no zone translation so 
> '2011-04-30 23:02:39.296282' will look the same whatever 
> the user uses for their timezone. (different datestyle
> settings can effect the date part however)

It is again stored internally as a number. 

 As I understand it: this number is the difference in 
milliseconds between "1970-01-01 00:00:00" and the time
given, for this computation both times are expressed in 
a region that does not do daylight saving or leap seconds 
(eg: UTC).  Most linux systems use a 64 bit integer, but
some oddball ones may use a 64 bit floating point number
instead.


-- 
⚂⚃ 100% natural