Postgres Pro
Downloads
Home   >   mailing lists

Re: reverse of extract epoch? - Mailing list pgsql-general

From Neil Conway
Subject Re: reverse of extract epoch?
Date
Msg-id 20020603093957.5db5e5c1.nconway@klamath.dyndns.org
Whole thread Raw
In response to reverse of extract epoch?  (Gregory Seidman <gss+pg@cs.brown.edu>)
Responses Re: reverse of extract epoch?  (Gregory Seidman <gss+pg@cs.brown.edu>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: strangeness in pg_dump
Next
From: Mathieu Arnold
Date:
Subject: Re: strangeness in pg_dump