postgresql 13位时间戳

时间：2020-06-18 21:52:49 收藏：0 阅读：210

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