Re: Calculating time fields

2002-08-17 Thread Paul DuBois
At 16:23 -0700 8/17/02, Todd Schacherl wrote: >Hi Folks, > >I have a MYSQL table with timeIn and a timeOut columns and I'm trying to >figure >out if I can calculate the difference within a SELECT statement. Both >fields are type TIME (e.g., 00:00:00). What units do you want the result in? To ge

Calculating time fields

2002-08-17 Thread Todd Schacherl
Hi Folks, I have a MYSQL table with timeIn and a timeOut columns and I'm trying to figure out if I can calculate the difference within a SELECT statement. Both fields are type TIME (e.g., 00:00:00). Thanks, Todd Schacherl [EMAIL PROTECTED] One of the penalties for refusing to participate in p