unix timestamp 转化为普通日期格式
不带时区的普通时间
TIMESTAMP WITHOUT TIME ZONE 'epoch' + (Unixtimestamp+3600*8) * INTERVAL '1 second' AS Unix timestamp
本文转自 pgmia 51CTO博客,原文链接:http://blog.51cto.com/heyiyi/1586636
unix timestamp 转化为普通日期格式
不带时区的普通时间
TIMESTAMP WITHOUT TIME ZONE 'epoch' + (Unixtimestamp+3600*8) * INTERVAL '1 second' AS Unix timestamp
本文转自 pgmia 51CTO博客,原文链接:http://blog.51cto.com/heyiyi/1586636