Article View: borland.public.interbase.sql
Article #11062Re: Can time field using sum to total up the time ?
From: kcchong
Date: Thu, 19 Dec 2002 05:33
Date: Thu, 19 Dec 2002 05:33
31 lines
2016 bytes
2016 bytes
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)
Technical Details
Message-ID:
<3e015a19$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3dffebe0$1@newsgroups.borland.com> <v4110v02107n586l1kvmn23lha7a9e76i8@4ax.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-18 21:38:52 PST From: "kcchong" <k_c_chong@yahoo.com> Sender: "kcchong" <k_c_chong@yahoo.com> Reply-To: "kcchong" <k_c_chong@yahoo.com> Subject: Re: Can time field using sum to total up the time ? Newsgroups: borland.public.interbase.sql X-User-Info: 203.121.0.10 203.121.0.10 X-Forwarded-For: 210.19.137.14 References: <3dffebe0$1@newsgroups.borland.com> <v4110v02107n586l1kvmn23lha7a9e76i8@4ax.com> NNTP-Posting-Host: 207.105.83.65 Message-ID: <3e015a19$1@newsgroups.borland.com> Date: 18 Dec 2002 21:33:13 -0800 X-Trace: newsgroups.borland.com 1040275993 207.105.83.65 (18 Dec 2002 21:33:13 -0800) Lines: 32 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail