postgreSQL

UNIX time → charactor 変換
TO_CHAR(‘1970-01-01’::DATE + ([field] || ‘S’)::INTERVAL, ‘YYYY-MM-DD’)