Re: Sum(time) possible?
От | Rich Shepard |
---|---|
Тема | Re: Sum(time) possible? |
Дата | |
Msg-id | Pine.LNX.4.33.0111030955000.24133-100000@salmo.appl-ecosys.com обсуждение исходный текст |
Ответ на | Re: Sum(time) possible? (Konstantinos Agouros <elwood@agouros.de>) |
Ответы |
Re: Sum(time) possible?
|
Список | 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 по дате отправления: