> If your field is a standard MySQL DATE/TIME field then > > HOUR(myfield) will extract the hour portion from myfield. > > Thus you can have > > WHERE HOUR(myfield) = 14
Yes, that is what i am doing now, but that is really slow, because all the dates, have to converted to strings, before MySQL can search the table. MySQL have to do a complete table scan when i use the HOUR() function. But thanks for the suggestion. Regards Emil -- Emil Rasmussen http://noget.net --------------------------------------------------------------------- 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
