How to format bigint field into a date in Postgresql?

sql postgresql date timestamp bigint

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

sql postgresql date timestamp bigint

This depends on what the bigint value represents - offset of epoch time, or not.

select to_timestamp(20120822193532::text, 'YYYYMMDDHH24MISS')

returns

"2012-08-22 19:35:32+00"

sql postgresql date timestamp bigint

This is what worked for me

to_timestamp( bigint_field/1000)::date

CodeHunter