| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | Konstantinos Agouros <elwood(at)agouros(dot)de> |
| Cc: | Andrew Gould <andrewgould(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Sum(time) possible? |
| Date: | 2001-11-03 17:57:24 |
| Message-ID: | Pine.LNX.4.33.0111030955000.24133-100000@salmo.appl-ecosys.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)appl-ecosys(dot)com
http://www.appl-ecosys.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Konstantinos Agouros | 2001-11-03 18:02:20 | Re: Sum(time) possible? |
| Previous Message | Command Prompt, Inc. | 2001-11-03 17:57:06 | Re: Sum(time) possible? |