Article View: borland.public.interbase.sql
Article #11071Re: Can time field using sum to total up the time ?
From: Bill Todd
Date: Fri, 20 Dec 2002 01:52
Date: Fri, 20 Dec 2002 01:52
41 lines
2419 bytes
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-mailReferences:
<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