Home > mailing lists

time zone problem - Mailing list pgsql-general

From	Cefull Lo
Subject	time zone problem
Date	January 13, 2012 15:07:58
Msg-id	CACqWm=EvKnHAZnb95-SfoTbitu03qMKOwHYwLyeWxgp9yTrW9w@mail.gmail.com Whole thread Raw
Responses	Re: time zone problem (Tom Lane <tgl@sss.pgh.pa.us>) Re: time zone problem (Cefull Lo <cefull@gmail.com>)
List	pgsql-general

Hi everybody,

I'm located in Hong Kong, UTC+8 time zone. When I

select current_timestamp;

gives

now

-------------------------------

2012-01-13 23:56:16.825558+08

However, when I

select current_timestamp at time zone 'UTC+8';

I expect the result is the same as the above one. But the result is

timezone

----------------------------

2012-01-13 07:57:24.407825

How to get the correct timestamp at the time zone I gave?

Thanks in advance

From: David Johnston
Date: 13 January 2012, 13:03:12
Subject: Re: Appending a newline to a column value - in a psql cronjob

From: "Hardy, Paul"
Date: 13 January 2012, 15:08:04
Subject: pg_bulkloader