PG 查询本地日期并转换为时间戳

select trim ( to_char ( extract ( epoch from current_date - integer''1 ) , ' 999999999 ' ) );