convert integer seconds to timestamp - Mailing list pgsql-sql

From Wilson Fletcher
Subject convert integer seconds to timestamp
Date
Msg-id 20031016133111.A7731@mclachlan.com.au
Whole thread Raw
Responses Re: convert integer seconds to timestamp  (Wilson Fletcher <research@mclachlan.com.au>)
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: "Zhao, Scott"
Date:
Subject: SQL function to validate money input
Next
From: Wilson Fletcher
Date:
Subject: Re: convert integer seconds to timestamp