SELECT CAST(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP )* 1000 AS int8),to_char(to_timestamp(CAST(EXTRACT(EPOCH FROM CURRENT_TIMESTAMP )* 1000 AS int8) / 1000) AT TIME ZONE ‘PRC‘, ‘yyyy-mm-dd hh24:mi:ss‘)
原文：https://www.cnblogs.com/BinBinGo/p/13159931.html