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

Article View: borland.public.interbase.sql

Article #11063

Back to borland.public.interbase.sql Previous Next

#11063

From: Brian
Date: Thu, 19 Dec 2002 09:56

14 lines
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

Technical Details

Message-ID: <3e0197e6$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!newshosting.com!news-xfer1.atl.newshosting.com!news.stealth.net!news.stealth.net!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!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 02:09:33 PST
From: "Brian" <brianellul@ecenglish.com>
Sender: "Brian" <brianellul@ecenglish.com>
Reply-To: "Brian" <brianellul@ecenglish.com>
Subject: Re: Can time field using sum to total up the time ?
Newsgroups: borland.public.interbase.sql
X-User-Info: 62.173.4.210 62.173.4.210    
References: <3dffebe0$1@newsgroups.borland.com> <v4110v02107n586l1kvmn23lha7a9e76i8@4ax.com> <3e015a19$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3e0197e6$1@newsgroups.borland.com>
Date: 19 Dec 2002 01:56:54 -0800
X-Trace: newsgroups.borland.com 1040291814 207.105.83.65 (19 Dec 2002 01:56:54 -0800)
Lines: 14
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news.stealth.net!news.stealth.net!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message