Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.7.5) with ESMTP id EAA08271 for ; Sun, 30 Aug 1998 04:39:29 -0400 (EDT) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id LAA20098; Sun, 30 Aug 1998 11:39:07 +0300 (IDT) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <13798.62017.463928.31800@majordomo.iac.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Sun, 30 Aug 1998 11:40:26 +0300 To: "Shawn T. Walker" From: Herouth Maoz Subject: Re: [SQL] Contertine timespan to hours Cc: pgsql-sql@postgreSQL.org At 21:17 +0300 on 28/8/98, Shawn T. Walker wrote: > > 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... testing=> \d test3 Table = test3 +-----------------------------+-----------------------------+-------+ | Field | Type | Length| +-----------------------------+-----------------------------+-------+ | ts | timespan | 12 | +-----------------------------+-----------------------------+-------+ testing=> SELECT * FROM test3; ts ------------------------ @ 6 days 4 hours 32 mins @ 200 days 3 hours @ 17 hours @ 3 hours 8 mins ago (4 rows) testing=> SELECT % ( date_part( 'epoch', ts ) / 3600 ) FROM test3; ?column? -------- 148 4803 17 -3 (4 rows) The date_part with 'epoch' converts the timespan to seconds. You convert it to hours by dividing by 3600, and you use % to round it. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma