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;"? Thanks, Alex Kirk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
