[SQL] converting epoch to timestamp

[Rajesh Kumar Mallah]

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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq