Re: reverse of extract epoch?

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: gss+pg(at)cs(dot)brown(dot)edu
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: reverse of extract epoch?
Date: 2002-06-03 13:39:57
Message-ID: 20020603093957.5db5e5c1.nconway@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 2 Jun 2002 21:17:50 -0400
"Gregory Seidman" <gss+pg(at)cs(dot)brown(dot)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(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mathieu Arnold 2002-06-03 13:50:23 Re: strangeness in pg_dump
Previous Message Jan Wieck 2002-06-03 13:35:52 Re: strangeness in pg_dump