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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roman Neuhauser <neuhauser(at)chello(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: int4 -> unix timestamp -> sql timestamp; abstime?
Date: 2005-01-12 00:31:19
Message-ID: 5581.1105489879@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Roman Neuhauser <neuhauser(at)chello(dot)cz> writes:
>> The recommended locution is
>>
>> SELECT TIMESTAMP WITH TIME ZONE 'epoch' + <x> * INTERVAL '1 second';

> Have I missed this in the manual?

The 8.0 docs mention this in the discussion of extract(epoch), but I'm
not sure if it was there before. It's been discussed in the mailing
list archives many times...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2005-01-12 00:40:25 Re: int4 -> unix timestamp -> sql timestamp; abstime?
Previous Message Roman Neuhauser 2005-01-12 00:28:58 Re: int4 -> unix timestamp -> sql timestamp; abstime?