Time Weirdness - Alex Kirk - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlTime Weirdness

From	Sent On	Attachments
Alex Kirk	22 Dec 2001 20:16
Bogdan Stancescu	23 Dec 2001 04:55
Alex Kirk	23 Dec 2001 10:36
Bogdan Stancescu	23 Dec 2001 12:15
Amer Neely	24 Dec 2001 08:15

Subject:	Time Weirdness
From:	Alex Kirk (al...@schnarff.com)
Date:	12/22/2001 08:16:02 PM
List:	com.mysql.lists.mysql

I've got a table that's acting as a timesheet, with time began and finished in each record. In order to do up an invoice based on that, I was making a total time field, which was just finish - start. It worked great for all of the records but two, where I had this result:

1 -- Start: 19:45:00 -- Finish: 20:00:00 -- Total: 55:00 2 -- Start: 17:50:00 -- Finish: 18:30:00 -- Total: 80:00

Obviously, these are erroneous values. It's not that this is always an issue when my hour field changes, as I've got several other records which work A-OK with different hours on start & finish.

Is this a bug in MySQL 3.23.37? Could it have something to do with my OS (OpenBSD 2.9)? Or am I doing something wrong with the statement "update time_worked set total = start - finish;"?