Convert date from long time postgres

SELECT timestamp 'epoch' + time_in_millisec * interval '1 ms'
FROM   mytable;

See the manual here.

Per PostgreSQL docs:

SELECT *, to_timestamp(time_in_milli_sec / 1000) FROM mytable