Re: time zone problem

[Cefull Lo <cefull@xxxxxxxxx>]

Hi,

I figure it out.

If only the offset from UTC is given, you may try

select current_timestamp at time zone (select name from pg_catalog.pg_timezone_names where utc_offset= interval '+8 hours' limit 1)

Would give the exact timestamp at those time zone.

On Fri, Jan 13, 2012 at 11:59 PM, Cefull Lo <cefull@xxxxxxxxx> wrote:

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

-- 
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GSC d- s:>++ a- C++ UL/B+++$ !P L++>+++++
E--- W+ N o-- K? w++ O? M- V- PS PE++(-) Y+
PGP++@ t 5 X R+>+++$ tv- b+++ DI++ D++
G++@ e+++>+++++ h*>--- r-- z?
-----END GEEK CODE BLOCK------