Posted by laredotornado@zipmail.com on 03/08/06 19:26

Hi,

I have two columns, both MySQL 4 DATETIME types ...

TABLE1.depart_day
TABLE2.depart_day

and both are indexed. The problem is, all of TABLE1's dates have a
time of midnight (e.g. 2006-03-08 00:00:00" while TABLE2's columns have
times (e.g. 2006-03-08 12:45:00). I want to match rows where TABLE1
and TABLE2's depart day columns match in terms of year, month, and day
(don't care about time). How can I do this and also make use of any
available indexes?

Thanks, - Dave

[Back to original message]