I have a TIMEDIFF statement that works in MYSQL, but not in C

[bsm2th]

In mysql, this statement gives a negative answer, meaning the start is a later time than the end. This won't work in C, because the hour variable is unsigned. Does anyone know of another way to tell whether or not a time comes before another time..

Thanks

Bob

The statement I used was

SELECT TIMEDIFF('01:00:00','02:00:00');

returns -01:00:00 in mysql, and 01:00:00 in C

[Atli]

Hi.

In MySQL the TIMEDIFF() function subtracts the second parameter from the first parameter and returns the result as a time value.

I can only guess that it works the other way around in C, unless it only returns absolute values?

[pbmods]

Heya, Bob.

Is it possible to declare the hour variable as signed?

Alternatively you could try TIME_TO_SEC(). Then at least you can compare and see if value 1 is less than value 2.

[bsm2th]

Found the answer elsewhere, it turns out that if there's a negative value returned by mysql, the C api shows it without the sign(the hour variable is unsigned in the C api), and the negative part of the answer is put in a boolean variable called neg attached to the MYSQL_TIME structure. Now I just need to make it work. Neg is always 1, whether the answer should be or not.

Bob