Posted by Richard Levasseur on 03/08/06 21:17

This is a mysql question and should be asked in a mysql groups.
Nonetheless:

try date_diff (if mysql > 4.1):
select foo from bar where date_diff(col1, col2) = 0

otherwise:
try using date_format or extract() then date_sub() to find the
difference

As for using the indices, I dunno.

[Back to original message]