Thread View: borland.public.interbase.sql
5 messages
5 total messages
Started by kcchong
Wed, 18 Dec 2002 03:30
Can time field using sum to total up the time ?
Author: kcchong
Date: Wed, 18 Dec 2002 03:30
Date: Wed, 18 Dec 2002 03:30
3 lines
1148 bytes
1148 bytes
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.
Re: Can time field using sum to total up the time ?
Author: Bill Todd
Date: Wed, 18 Dec 2002 14:24
Date: Wed, 18 Dec 2002 14:24
15 lines
1527 bytes
1527 bytes
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)
Re: Can time field using sum to total up the time ?
Author: 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)
Re: Can time field using sum to total up the time ?
Author: Brian
Date: Thu, 19 Dec 2002 09:56
Date: Thu, 19 Dec 2002 09:56
14 lines
1683 bytes
1683 bytes
>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. Hi If I understood well, you're storing the difference between two time fields. I suggest that you store this value in a decimal field type since as such it's not a time value but a time diffenence value. In this way, you'll be able to SUM up with SQL. Regards Brian
Re: Can time field using sum to total up the time ?
Author: 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)
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads