time zone problem

From: Cefull Lo <cefull(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: time zone problem
Date: 2012-01-13 15:59:56
Message-ID: CACqWm=EvKnHAZnb95-SfoTbitu03qMKOwHYwLyeWxgp9yTrW9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-01-13 16:18:27 Re: time zone problem
Previous Message Hardy, Paul 2012-01-13 15:07:16 pg_bulkloader