Groups > comp.databases.postgresql > #106

Re: timestamp and time zone

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> (permalink)
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%m0YyyvgkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g\|E2#EhjKCa+nt":4b}dU7GYBHBxn&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

Show key headers only | View raw

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

Back to comp.databases.postgresql | Previous | Next — Previous 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