Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8F93L727052 for ; Sat, 15 Sep 2001 05:03:21 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8F8ptD06211 for pgsql-sql@postgresql.org; Sat, 15 Sep 2001 04:51:55 -0400 (EDT) (envelope-from news) From: Hans-Juergen Schoenig X-Newsgroups: comp.databases.postgresql.sql Subject: Re: How to Get Timestamp From SECONDS? Date: Sat, 15 Sep 2001 10:56:57 +0200 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 13 Message-ID: <3BA317D9.480EB2F3@bachata.cybertec.at> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.77 [de] (X11; U; Linux 2.4.9-xfs i686) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200109/109 X-Sequence-Number: 4774 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