Postgres Pro
Downloads
Home   >   mailing lists

converting unix seconds to timestamp - Mailing list pgsql-sql

From Alexei Chetroi
Subject converting unix seconds to timestamp
Date
Msg-id 20040423084651.GA1207@uniflux-line.net
Whole thread Raw
Responses Re: converting unix seconds to timestamp  (Alexei Chetroi <lexoid@lexa.uniflux-line.net>)
List pgsql-sql
Tree view 
Hi,
I wish to convert unix seconds which are from 1970 to timestamp and connot
find appropriate function for it. I know how to convert timestamp to unix
second with extract(epoch FROM ...) but not reverse. Please Help.
Regards

--
Alexei Chetroi

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Server Side C programming Environment Set up
Next
From: "Denis P Gohel"
Date:
Subject: Record Lock details