Re: reverse of extract epoch?

On Sun, 2 Jun 2002 21:17:50 -0400
"Gregory Seidman" <gss+pg@cs.brown.edu> wrote:
> Now I want to create its reverse so I can get a timestamp (with tz) from an
> epoch-based integer. Is there some simple way of doing it?

Try:

select "timestamp"(extract(epoch from now())::int);

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC