pgsql 时间转时间戳

extract(epoch from to_timestamp(to_char("",'yyyy-MM-DD hh24:mi:ss'),'yyyy-MM-DD hh24:mi:ss'))*1000 as time
原文地址:https://www.cnblogs.com/cjb1/p/14637002.html