Re: time zone problem

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(at)gmail(dot)com> 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------