Go4Expert - View Single Post

pradeep

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

pradeep Team Leader
30May2009,15:03
	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