Received: from mjtsa.com (mjtgtw2.mjt.ch [194.209.241.21]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0OCc3095428 for ; Wed, 24 Jan 2001 07:38:03 -0500 (EST) (envelope-from bc@mjtsa.com) Received: (from bc@localhost) by mjtsa.com (8.9.2/dc) id NAA16274 for pgsql-sql@postgresql.org; Wed, 24 Jan 2001 13:38:31 GMT Date: Wed, 24 Jan 2001 13:38:31 GMT From: Blaise Carrupt Message-Id: <200101241338.NAA16274@mjtsa.com> To: pgsql-sql@postgresql.org Subject: Convert an interval in seconds Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-MD5: PawTLc/uhXvBWlbZLerLkA== X-Archive-Number: 200101/321 X-Sequence-Number: 993 Hi all ! I've search all the doc to find a function which would allow me to convert an interval into a number of seconds. What I get is @ 1 hour, what I would like is -3600. I'd think to something like select interval('sec', myTime) - Ingres syntax - but it doesn't work. Does somebody has an idea ? ______________ B. Carrupt