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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: int4 -> unix timestamp -> sql timestamp; abstime?
Дата
Msg-id 5581.1105489879@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: int4 -> unix timestamp -> sql timestamp; abstime?  (Roman Neuhauser <neuhauser@chello.cz>)
Ответы Re: int4 -> unix timestamp -> sql timestamp; abstime?
Список pgsql-general
Дерево обсуждения 
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 по дате отправления: