int4 -> unix timestamp -> sql timestamp; abstime? - Mailing list pgsql-general

From Roman Neuhauser
Subject int4 -> unix timestamp -> sql timestamp; abstime?
Date
Msg-id 20050111231025.GD4463@isis.wad.cz
Whole thread Raw
Responses Re: int4 -> unix timestamp -> sql timestamp; abstime?
List 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

pgsql-general by date:

Previous
From: Eric Brown
Date:
Subject: Running a void function in psql
Next
From: Tom Lane
Date:
Subject: Re: Running a void function in psql