Hi Not sure if this is a bug or not. I am doing a sql query for time difference using the TIMEDIFF function. It works for all other but not when not when you are doing a time difference for start time 23:00:00 (11 PM night) and end time 00:30:00 (12 AM Midnight) if you take a look, the difference is 1.5 hours, but the sql tells me that the difference is 22 hours, 30 minutes Any solution to this? Thanx
Logically what MySQL returns is correct, 00 hr onwards is next day, so you must include the date part! Code: select timediff('2009-05-28 11:30:00','2009-05-28 00:30:00') Outputs: Code: 11:00:00
