X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C137E475E3E for ; Wed, 12 Feb 2003 09:37:05 -0500 (EST) Received: from firewally.lvh.dnet.it (unknown [194.242.196.107]) by postgresql.org (Postfix) with ESMTP id 9EDB4475E30 for ; Wed, 12 Feb 2003 09:37:04 -0500 (EST) Received: from idefix.lvh.dnet.it (idefix [192.168.1.11]) by firewally.lvh.dnet.it (8.11.6/8.11.6) with ESMTP id h1CEb7m16317 for ; Wed, 12 Feb 2003 15:37:07 +0100 Received: by idefix.lvh.dnet.it with Internet Mail Service (5.5.2650.21) id <1GQ7HSHM>; Wed, 12 Feb 2003 15:37:07 +0100 Message-ID: <418DEFFAA399D311818A00508B912F2883D74A@idefix.lvh.dnet.it> From: Plant Thomas To: pgsql-sql@postgresql.org Subject: Sum of Intervals Date: Wed, 12 Feb 2003 15:37:07 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/240 X-Sequence-Number: 11638 Hello, I'm trying to do a sum() of some time intervals. I get the result as: '1 day 02:30' which is ok, but is there a function which converts this to hours or do I have to write my own? For example the '1 day 02:30' should become 26:30 hours. Thanks for any advice, Thomas