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 <cef...@gmail.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------
