I like to use the TIMEDIFF and DATEDIFF functions of MySQL 4.1 to find the difference down the second of two dates...
I have searched the MySQL documentation but I can only find how to find the difference between two dates in days in MySQL versions below 4.1.
TO_DAYS(somefield) - TO_DAYS(somefield) works, but I need to know the difference in time too. Any ideas?