Received: from cti13.citenet.net (cti13.citenet.net [206.123.38.75]) by hub.org (8.10.1/8.10.1) with ESMTP id e58JaMT61942 for ; Thu, 8 Jun 2000 15:36:22 -0400 (EDT) Received: from zack (g92-180.citenet.net [209.41.140.180]) by cti13.citenet.net (8.9.3/8.9.1) with SMTP id PAA83987 for ; Thu, 8 Jun 2000 15:26:02 -0400 (EDT) From: "Ed" To: "pgsql sql" Subject: =?iso-8859-1?Q?Sum_of_datetime_diff=E9rence...?= Date: Thu, 8 Jun 2000 15:39:58 -0400 Message-ID: <000901bfd181$544297e0$b48c29d1@citenet.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200006/97 Hi, I would like to know what is the easiest way to add multiple difference of datetime but show the result in hour and minute something like : table foo: start datetime end datetime I would like to do : select sum(end-start) from foo; but it gives me 3 days 12 hours 23 minutes...etc I would like to see 84 hours and 23 minutes... How can I do this? PS: Is there a way to know which week of the year a current day is in? Frédéric Boucher Ed@jetumele.com