EXTRACT(EPOCH FROM "dt"::timestamp with time zone) 
82800

TO_TIMESTAMP("sec"::bigint)::timestamp
1970-01-02 01:00:00