Hi ! I have a table with 2 coluns with time values , for example, colum START ("2001-11-20 23:34:03" , for example) and STOP ("2001-11-21 08:34:03" , for example). Given a interval of time, say 8 AM to 8 PM, i need my query to return the total time between START and STOP outside this period. Is this possible to be done with SQL ? Thnx a lot ! Julio
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php