How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ? - Mailing list 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