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.

• Next in forum: Apache 2.0, php 5 and mysql + win xp
• Prev in forum: Re: New to OO programming
• Thread view: Re: Comparing indexed MySQL datetime columns

[Reply to this message]