Home > mailing lists

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

From	Roman Neuhauser
Subject	int4 -> unix timestamp -> sql timestamp; abstime?
Date	January 12, 2005 02:10:43
Msg-id	20050111231025.GD4463@isis.wad.cz Whole thread Raw
Responses	Re: int4 -> unix timestamp -> sql timestamp; abstime? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

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:

From: Eric Brown
Date: 12 January 2005, 02:07:21
Subject: Running a void function in psql

From: Tom Lane
Date: 12 January 2005, 02:33:13
Subject: Re: Running a void function in psql

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

Previous

Next