converting epoch to timestamp

From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: converting epoch to timestamp
Date: 2005-10-26 09:05:51
Message-ID: a97c77030510260205n246dcec7rad2818eee629c15@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Can anyone tell me how to convert epoch to timestamp ?

ie reverse of :

SELECT EXTRACT( epoch FROM now() );
+------------------+
| date_part |
+------------------+
| 1130317518.61997 |
+------------------+
(1 row)

Regds
mallah.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-10-26 09:22:25 Re: converting epoch to timestamp
Previous Message Richard Huxton 2005-10-26 08:31:48 Re: broken join optimization? (8.0)