Unix timestamp to postgres timestamp

From Flo's Knowledge in a Nutshell

The easy way converting a unix timestamp to a postgres timestamp, eg ex. using date_part afterwards:

SELECT my_unixtimestamp::abstime as pg_time;