[thelist] sql query for sum of timediff
Tab Alleman
talleman at Lumpsum.com
Fri Jun 2 09:11:04 CDT 2006
If you do this, do you get any rows?:
select *
from presence
where starttime is null OR endtime is null
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Canfield, Joel
> Sent: Thursday, June 01, 2006 7:34 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] sql query for sum of timediff
>
>
> > select firstname, lastname, sum(timediff(endtime,starttime))
> > from presence
> > where starttime between '2006-05-31 0:00:00' and
> '2006-05-31 23:59:59'
> > group by firstname, lastname
>
> this returns zero sums in places I know there to be data (names are
> unique)
>
> still working on it
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list