| From: | "Shawn T(dot) Walker" <swalker(at)iac(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Contertine timespan to hours |
| Date: | 1998-08-28 18:17:31 |
| Message-ID: | 13798.62017.463928.31800@majordomo.iac.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)iac(dot)net
Internet Access Cincinnati
http://www.iac.net
"Running enterprise applications on NT? Let the torture begin."
- A Sun Microsystems Inc. banner ad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herouth Maoz | 1998-08-30 08:40:26 | Re: [SQL] Contertine timespan to hours |
| Previous Message | Guido Piazzi | 1998-08-28 08:52:14 | Re: [SQL] Absolute value on int2 or int4 field |