How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?

Поиск
Список
Период
Сортировка
От Bruno BAGUETTE
Тема How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Дата
Msg-id !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAh1Q5KepghEKYSNnycVl0awEAAAAA@baguette.net
обсуждение исходный текст
Ответы Re: How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Re: How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Список pgsql-general
Дерево обсуждения 
Hello,

I'm looking for a way to convert a unix timestamp to a PostgreSQL date
without using ::abstime which seems to be deprecated.

Currently, I do that query :

levure=> select 1063147331.843::int4::abstime;
        abstime
------------------------
 2003-09-10 00:42:12+02
(1 row)


What can I use to replace the abstime type in ?

Thanks in advance :-)

---------------------------------------
Bruno BAGUETTE - pgsql-ml@baguette.net

В списке pgsql-general по дате отправления: