Re: [SQL] How to Get Timestamp From SECONDS?

[Hans-Juergen Schoenig]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster