Find the difference between two datetime values in seconds, minutes, hours or days. If dt1 and dt2 are datetime values of the form 'yyyy-mm-dd hh:mm:ss', the number of seconds between dt1 and dt2 is
UNIX_TIMESTAMP( dt2 ) - UNIX_TIMESTAMP( dt1 )To get the number of minutes divide by 60, for the number of hours divide by 3600, and for the number of days, divide by 3600 * 24. Last updated 22 May 2009 |