Postgres Pro
Downloads
Home   >   mailing lists

converting epoch to timestamp - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject converting epoch to timestamp
Date
Msg-id a97c77030510260205n246dcec7rad2818eee629c15@mail.gmail.com
Whole thread Raw
Responses Re: converting epoch to timestamp  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: converting epoch to timestamp  (Richard Huxton <dev@archonet.com>)
Re: converting epoch to timestamp  (Stef <svb@ucs.co.za>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: broken join optimization? (8.0)
Next
From: "A. Kretschmer"
Date:
Subject: Re: converting epoch to timestamp