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