Postgres Pro
Downloads
Home   >   mailing lists

Contertine timespan to hours - Mailing list pgsql-sql

From Shawn T. Walker
Subject Contertine timespan to hours
Date
Msg-id 13798.62017.463928.31800@majordomo.iac.net
Whole thread Raw
Responses Re: [SQL] Contertine timespan to hours  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Guido Piazzi
Date:
Subject: Re: [SQL] Absolute value on int2 or int4 field
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] Contertine timespan to hours