Re: How to Get Timestamp From SECONDS?

From: Hans-Juergen Schoenig <hs(at)bachata(dot)cybertec(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to Get Timestamp From SECONDS?
Date: 2001-09-15 08:56:57
Message-ID: 3BA317D9.480EB2F3@bachata.cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-09-16 04:34:15 Re: optimizing queries and indexes...
Previous Message Hans-Juergen Schoenig 2001-09-15 08:48:02 Re: Checking for table existence