Re: Sum(time) possible? - Mailing list pgsql-general

From Rich Shepard
Subject Re: Sum(time) possible?
Date
Msg-id Pine.LNX.4.33.0111030955000.24133-100000@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Sum(time) possible?  (Konstantinos Agouros <elwood@agouros.de>)
Responses Re: Sum(time) possible?  (Konstantinos Agouros <elwood@agouros.de>)
List pgsql-general
On Sat, 3 Nov 2001, Konstantinos Agouros wrote:

> Yup. A little background the column hold the time someone works on a project.
> At the end of the month I want to see the total time. If time is not the right
> column type for this please let me know.

Konstantin,

  I keep my time records as decimals (to the nearest quarter-hour). Then
it's a simple matter to add 3.25, 7.5, and so on.

  If the time is clock time, perhaps you can convert it to decimal hours
before summing.

HTH,

Rich

Dr. Richard B. Shepard, President

                       Applied Ecosystem Services, Inc. (TM)
            2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
 + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com
                         http://www.appl-ecosys.com


pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Re: Sum(time) possible?
Next
From: "Command Prompt, Inc."
Date:
Subject: Re: how do the pro's do this? (still a newbie)