postgre 计算两个日期相减
date_part('day', cast(time1 as TIMESTAMP)- cast(time2 as TIMESTAMP))
select date_part('day', current_date - UPDATE_PWD_DATE ) from pure_user;
date_part('day', cast(time1 as TIMESTAMP)- cast(time2 as TIMESTAMP))
select date_part('day', current_date - UPDATE_PWD_DATE ) from pure_user;