Thanks! Worked perfectly. And also thanks to the other people who
responded. Being unfamiliar with how MySQL seems to handle time your
responses really helped!
-Chris
On Jun 27, 2005, at 1:16 PM, [EMAIL PROTECTED] wrote:
That would have worked if TIME values weren't converted to numbers
[EMAIL PROTECTED] wrote:
Christopher Molnar <[EMAIL PROTECTED]> wrote on 06/27/2005
12:55:08 PM:
What I would like to use is:
select ctype, count(tsid), sum(amount), sum(amount_collected), sum
(camount), sum(commision), sum(subtime(time_out,dispatch_time)) as
time from time_sheet where t
Christopher Molnar <[EMAIL PROTECTED]> wrote on 06/27/2005
12:55:08 PM:
> I have a table that has the following structure:
> mysql> describe time_sheet;
> +--+---+--+-+
> ++
> | Field| Type | Null | Key | Defaul
I have a table that has the following structure:
mysql> describe time_sheet;
+--+---+--+-+
++
| Field| Type | Null | Key | Default|
Extra |
+--+---+--+-+---