Received: from smtp10.atl.mindspring.net (smtp10.atl.mindspring.net [207.69.200.246]) by hub.org (8.10.1/8.10.1) with ESMTP id e7RC62I98572 for ; Sun, 27 Aug 2000 08:06:02 -0400 (EDT) Received: from hbg-b467.mindspring.com (fw-5-e3.atl2.mindspring.net [207.69.162.92]) by smtp10.atl.mindspring.net (8.9.3/8.8.5) with ESMTP id IAA26399 for ; Sun, 27 Aug 2000 08:06:01 -0400 (EDT) Message-Id: <4.3.2.7.2.20000827080015.00b54540@pop> X-Sender: bcdoyle@pop X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Sun, 27 Aug 2000 08:05:31 -0400 To: pgsql-sql@postgresql.org From: "Brian C. Doyle" Subject: Time Results Conversion Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200008/287 Hello all, I have now upgraded to 7.0.2 and am very pleased with it. I do have a question about a result that I am getting. When I sum an interval field will get "1 01:01:01" representing "25 hours 1 minute 1 second" The result that I need is just the sum of the hours minutes and seconds and No days!!!! ie roll the day back into the hour field. Is it possible for me to do this and if so How?