MySQL Time Difference BUG

cancer10's Avatar, Join Date: Jul 2008
Go4Expert Member
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
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
That means it takes the date into account and assumes the same day.
0
pradeep's Avatar, Join Date: Apr 2005
Team Leader
Logically what MySQL returns is correct, 00 hr onwards is next day, so you must include the date part!

Code: SQL
SELECT timediff('2009-05-28 11:30:00','2009-05-28 00:30:00')

Outputs:
Code:
11:00:00