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