Thread: How to Get Timestamp From SECONDS?
Hi all, Consider this.. SELECT EXTRACT(EPOCH FROM TIMESTAMP(now()));date_part ------------1000467997 (1 row) Fine.. Similarly, how could i get timestamp value for SECONDS? ie.. VICE VERSA Something like this.. :) select extract(timestamp from interval('1000467997 seconds')); :) Kindly Apologize for any inconvenience. ====================================================================== "Help Mr. Wizard!" -- Tennessee Tuxedo ====================================================================== Regards, Bhuvaneswar.
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
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
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