Postgres Pro
Downloads
Home   >   mailing lists

Re: How to Get Timestamp From SECONDS? - Mailing list pgsql-sql

From Hans-Juergen Schoenig
Subject Re: How to Get Timestamp From SECONDS?
Date
Msg-id 3BA317D9.480EB2F3@bachata.cybertec.at
Whole thread Raw
In response to How to Get Timestamp From SECONDS?  (Bhuvan A <bhuvansql@yahoo.com>)
List pgsql-sql
Tree view 
Try it with something like that:

mydata=# SELECT '1-1-2001'::timestamp + '200 seconds'::interval;       ?column?
------------------------2001-01-01 00:03:20+01
(1 row)


epoch + seconds = desired timestamp.
   Hans

pgsql-sql by date:

Previous
From: "Julester"
Date:
Subject: Checking for table existence
Next
From: Carl van Tast
Date:
Subject: Re: group by weirdness