Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: int4 -> unix timestamp -> sql timestamp; abstime?
Date
Msg-id 5581.1105489879@sss.pgh.pa.us
Whole thread Raw
In response to Re: int4 -> unix timestamp -> sql timestamp; abstime?  (Roman Neuhauser <neuhauser@chello.cz>)
Responses Re: int4 -> unix timestamp -> sql timestamp; abstime?  (Roman Neuhauser <neuhauser@chello.cz>)
List pgsql-general
Tree view 
Roman Neuhauser <neuhauser@chello.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

pgsql-general by date:

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