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

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Roman Neuhauser <neuhauser(at)chello(dot)cz>, pgsql-general(at)postgresql(dot)org
Subject: Re: int4 -> unix timestamp -> sql timestamp; abstime?
Date: 2005-01-12 00:12:12
Message-ID: 9B684894-642E-11D9-8228-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roman Neuhauser 2005-01-12 00:28:58 Re: int4 -> unix timestamp -> sql timestamp; abstime?
Previous Message Tom Lane 2005-01-11 23:35:18 Re: int4 -> unix timestamp -> sql timestamp; abstime?