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 по дате отправления:

Предыдущее
От: Andrew Gould
Дата:
Сообщение: Re: Sum(time) possible?
Следующее
От: "Command Prompt, Inc."
Дата:
Сообщение: Re: how do the pro's do this? (still a newbie)