postgreSQL获得两个日期之间的时间差的天数

select date_part('day',cast(su.expire_time as TIMESTAMP)-cast(now() as TIMESTAMP)) from tb_ship_upload as su 

原文地址:https://www.cnblogs.com/HQ0422/p/11471356.html