Received: from majordomo.iac.net (swalker@majordomo.iac.net [199.6.32.154]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA04336 for ; Fri, 28 Aug 1998 13:16:18 -0400 (EDT) Received: (from swalker@localhost) by majordomo.iac.net (8.9.1/8.8.8) id NAA00725; Fri, 28 Aug 1998 13:17:31 -0500 From: "Shawn T. Walker" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Date: Fri, 28 Aug 1998 13:17:31 -0500 (EST) To: pgsql-sql@postgreSQL.org Subject: Contertine timespan to hours X-Mailer: VM 6.43 under 20.4 "Emerald" XEmacs Lucid Message-ID: <13798.62017.463928.31800@majordomo.iac.net> All, I have a table of a timespan. I get it in days,hours,and minutes. I need to convert the entire thing to hours. select sum(totaltime) from usage1998; returns: sum ------------------------------------- @ 12468 days 23 hours 40 mins 45 secs (1 row) I need thevalue in just hours... Can anyone give me a hand... Thanks in advance!:) -- Shawn T. Walker swalker@iac.net Internet Access Cincinnati http://www.iac.net "Running enterprise applications on NT? Let the torture begin." - A Sun Microsystems Inc. banner ad