🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #11071

Re: Can time field using sum to total up the time ?

#11071
From: Bill Todd
Date: Fri, 20 Dec 2002 01:52
41 lines
2419 bytes
You cannot store a time interval in a Time field. Store the interval
in an integer or NUMERIC field. Then you will be able to sum it.

On 18 Dec 2002 21:33:13 -0800, "kcchong" <k_c_chong@yahoo.com> wrote:

>
>Hi Bill,
>
>In delphi I already calculated the interval time between tester down time and tester up time then store the calculated 
>time in IB6 time field. I want to sum up this field based on certain criteria to generate report or chart, for example by weekly,
>tester number, area and etc.
>
>thanks
>
>rgds
>kcchong
>
>
>
>
>Bill Todd <bill@notthis.dbginc.com> wrote:
>>The concept of summing times makes no sense. What is the sum of 9:00
>>AM and 3:00 PM? I suspect what you want to do is sum time intervals
>>but that is just a guess since you have not provided any detailed
>>information about your problem.
>>
>>On 17 Dec 2002 19:30:40 -0800, "kcchong" <k_c_chong@yahoo.com> wrote:
>>
>>>
>>>If can't use this method to sum time as usual use it to sum integer and float field. So do you have any idea to sum it in 
>>>more simple way because i'm doing the downtime tracking project.
>>
>>
>>--
>>Bill (TeamB)
>>(TeamB cannot respond to questions received via email)


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
Technical Details
Message-ID: <ntt40v4jebjke0g3j34ms1k2ao0fv4rkq3@4ax.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!DIRECTV!203.109.225.2!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <3dffebe0$1@newsgroups.borland.com> <v4110v02107n586l1kvmn23lha7a9e76i8@4ax.com> <3e015a19$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,20a22b52b7a25b78
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-19 18:06:09 PST
From: Bill Todd <bill@notthis.dbginc.com>
Newsgroups: borland.public.interbase.sql
Subject: Re: Can time field using sum to total up the time ?
Date: Thu, 19 Dec 2002 18:52:43 -0700
Message-ID: <ntt40v4jebjke0g3j34ms1k2ao0fv4rkq3@4ax.com>
References: <3dffebe0$1@newsgroups.borland.com> <v4110v02107n586l1kvmn23lha7a9e76i8@4ax.com> <3e015a19$1@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.207.211.28
X-Trace: newsgroups.borland.com 1040349162 216.207.211.28 (19 Dec 2002 17:52:42 -0800)
Lines: 41
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!DIRECTV!203.109.225.2!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail