On 20 Nov 2002, at 14:40, Felipe D. Ramalho wrote: > SELECT ..., B.dthr_occurrence as open, > DATE_SUB(C.dthr_occurrence, INTERVAL B.dthr_occurrence > HOUR_MINUTE) AS during, > DATE_SUB(D.dthr_occurrence, INTERVAL B.dthr_occurrence > HOUR_MINUTE) AS late > > FROM CALL A, OCCURRENCE B, OCCURRENCE C, OCCURRENCE D
The DATE_SUBs in your query make no sense. You're treating the same column as both a date and an "HH:MM" string representing a duration in hours and minutes. It can't be both. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- 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
