How to format bigint field into a date in Postgresql? February 28, 2023 by Tarik TO_CHAR(TO_TIMESTAMP(bigint_field / 1000), 'DD/MM/YYYY HH24:MI:SS')