pg 查询timestamp转日期

(select to_date(max(gxsj)::text,'YYYY-MM-DD') from app.app_d_kpfx_syztfxxxsj)