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.