Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Glaesemann
Subject Re: int4 -> unix timestamp -> sql timestamp; abstime?
Date
Msg-id 9B684894-642E-11D9-8228-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: int4 -> unix timestamp -> sql timestamp; abstime?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Jan 12, 2005, at 8:35, Tom Lane wrote:

> The recommended locution is
>
> SELECT TIMESTAMP WITH TIME ZONE 'epoch' + <x> * INTERVAL '1 second';
>
> Of course you can wrap this up in a function if you prefer (not sure
> why
> we haven't done so already).

It's in the queue for 8.1.

<http://candle.pha.pa.us/mhonarc/patches2/msg00090.html>

Michael Glaesemann
grzm myrealbox com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: int4 -> unix timestamp -> sql timestamp; abstime?
Next
From: Roman Neuhauser
Date:
Subject: Re: int4 -> unix timestamp -> sql timestamp; abstime?