例如,1481294792应转换为2016-12-09 14:46:32.
我尝试了SELECT to_timestamp(1481294792):: timestamp,但这给了我2016-12-09 09:46:32.
SELECT to_timestamp(1481294792) AT TIME ZONE 'UTC';
资料来源:https://dba.stackexchange.com/a/61345/33877