--日期转时间戳SELECT EXTRACT(epoch FROM NOW()); SELECT EXTRACT(epoch FROM CAST('2017-12-06 00:17:10' AS TIMESTAMP)); --时间戳转日期SELECT TO_TIMESTAMP(1512490630)
本文共 207 字，大约阅读时间需要 1 分钟。
--日期转时间戳SELECT EXTRACT(epoch FROM NOW()); SELECT EXTRACT(epoch FROM CAST('2017-12-06 00:17:10' AS TIMESTAMP)); --时间戳转日期SELECT TO_TIMESTAMP(1512490630)
转载于:https://www.cnblogs.com/binguo2008/p/8012496.html