hi John,
Thank you for your reply. I am in China.
You can look at my result as following:
show timezone;
TimeZone
----------
PRC
(1 row)
# update history_configuration set var_datetime = 'Wed Dec 24 18:52:46 CST 2014' where var_name = 'lastHourAggr';
# select * from history_configuration ;
var_name | var_value | var_datetime
-------------------+-----------+------------------------
lastHourAggr | | 2014-12-25 08:52:46+08
So I think this CST means Central Standard Time , right? And then when I read data using select sql, it will show this time with postgresql timezone.