How to format bigint field into a date in Postgresql?

This is what worked for me

to_timestamp( bigint_field/1000)::date

TO_CHAR(TO_TIMESTAMP(bigint_field / 1000), 'DD/MM/YYYY HH24:MI:SS')