stupidly.... My DateTime field is in this format: March 23, 2005, 3:49 pm
If I want to run this sql.... SELECT TO_DAYS(MAX(DateTime)) - TO_DAYS(MIN(DateTime)) AS record FROM userLog
I gather I need some extra function like...... SELECT TO_DAYS(MAX(Convert _Function(DateTime))) - TO_DAYS(MIN(Convert _Function(DateTime))) AS record FROM userLog
what is that magic function ?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]