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

From: "Bruno BAGUETTE" <pgsql-ml(at)baguette(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to convert a UnixTimestamp to a PostgreSQL date without using ::abstime ?
Date: 2003-09-09 23:47:20
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAh1Q5KepghEKYSNnycVl0awEAAAAA@baguette.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)baguette(dot)net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kathy Zhu 2003-09-10 00:13:13 Re: encoding again
Previous Message Peter Eisentraut 2003-09-09 22:57:30 Re: encoding again