1、这个比较准确
select floor(extract(epoch from now()));
2、获取数据库中毫秒级
select floor(extract(epoch from((current_timestamp - timestamp '1970-01-01 00:00:00')*1000)));
3、获取系统中秒级的时间
select floor(extract(epoch from(current_timestamp - timestamp '1970-01-01 00:00:00')));