Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!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: 1 May 2011 11:33:02 GMT
Organization: Dis (not Dat) Organisation
Lines: 23
Message-ID: <ipjgde$9uo$1@reversiblemaps.ath.cx>
References: <91th8nFmufU1@mid.uni-berlin.de> <ipgr0s$rf5$1@reversiblemaps.ath.cx> <922ptdFcr5U1@mid.uni-berlin.de>
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: Sun, 1 May 2011 12:00:37 +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:OdvCiZPOXhWuZIpUvCLMGbhF4FY=
Xref: x330-a1.tempe.blueboxinc.net comp.databases.postgresql:106

On 2011-04-30, M. Strobel <sorry_no_mail_here@nowhere.dee> wrote:

> I see. So there is no automatic translation 'without time zone',
> but if you ask the system to translate it to another time zone it
> does so assuming local time.
>
> Thanks, I thought it was too much work to set up tests within
> different time zones...

you can temporarily change the timezone that postres considers local 
to you with the 

"set timezone to " command 
eg:

  set timezone to "Asia/Singapore"; 
  select now();

this makes testing other zones easy.


-- 
⚂⚃ 100% natural