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