> I am not sure I quite understand your problem, but doen't the BETWEEN ... > AND operator > solve your problem? All you have to do is to format the limits in a way > that MySQL understands > to be a timestamp, and it should then do a proper date comparison.
Nope, the BETWEEN AND operator does not work either. I would like to know how to format the limits, so that MySQL understands that i want the results from a particular hour? 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