Just forwarding this to the list.
On Wednesday, March 30, 2005 10:43, Christopher Vaughan wrote:
> Tom Crimmins on Wednesday, March 30, 2005 at 11:31 AM -0500 wrote:
>> Look at the functions HOUR(time), MINUTE(time), SECOND(time). These
>> will give you interger output for each part of the time
"Christopher Vaughan" <[EMAIL PROTECTED]> wrote on 30/03/2005 16:48:47:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
> I want to break each part of the data into different parts based on
> the ':' to separate them. Then I want to take that data and sum it.
I think I remember a match_at(":") or pat_index(":") UDF which would
return the position of the first ":" for you, but I can't find it if it
does exist.
On Wed, 30 Mar 2005, Christopher Vaughan wrote:
>I have data in a table listed as
>44:22:22
>333:33:33
>It stands for hhh:mm:ss
>I want to b
On Wednesday, March 30, 2005 10:24, Christopher Vaughan wrote:
> Tom Crimmins on Wednesday, March 30, 2005 at 11:10 AM -0500 wrote:
>> If you convert it to a time field you can use mysql built-in
>> functions to do what you want. You are limited to the range
>> -838:59:59 to 838:59:59 though.
>
On Wednesday, March 30, 2005 09:49, Christopher Vaughan wrote:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
If you convert it to a time field you can use mysql built-in functions
to do what you want. You are limited to the range -838:59:59 to
838:59:59 th
I have data in a table listed as
44:22:22
333:33:33
It stands for hhh:mm:ss
I want to break each part of the data into different parts based on the ':' to
separate them. Then I want to take that data and sum it. I wrote an if
statement to parse through this table but I can't get it to work. I
