convert integer seconds to timestamp

How can I convert epoch seconds (as an interger) to a timestamp ?

I've already seen the post below BUT it doesn't work. I suspect it is out of date:
http://archives.postgresql.org/pgsql-sql/2000-09/msg00190.php

thanks.