int4 -> unix timestamp -> sql timestamp; abstime?

From: Roman Neuhauser <neuhauser(at)chello(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: int4 -> unix timestamp -> sql timestamp; abstime?
Date: 2005-01-11 23:10:25
Message-ID: 20050111231025.GD4463@isis.wad.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

what is the opposite of cast(extract('epoch' from now()) as int)?
The only thing I found that works is
cast(cast(... as abstime) as timestamp)
and the documentation says abstime shouldn't be used, and may
disappear. What should I use instead?

--
FreeBSD 4.10-STABLE
12:01AM up 15:39, 7 users, load averages: 0.08, 0.04, 0.01

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-01-11 23:32:57 Re: Running a void function in psql
Previous Message Eric Brown 2005-01-11 23:06:54 Running a void function in psql