From: Shawn T. Walker <swalker@iac.net>
To: pgsql-sql@postgreSQL.org
Subject: Contertine timespan to hours
Date: Fri, 28 Aug 1998 13:17:31 -0500 (EST)
Message-ID: <13798.62017.463928.31800@majordomo.iac.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: swalker@iac.net
Subject: Re: Contertine timespan to hours
In-Reply-To: <13798.62017.463928.31800@majordomo.iac.net>
References: <13798.62017.463928.31800@majordomo.iac.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox