> Select * from <TABLE> where date > _2005-01-07_ and date < > DATE_ADD(_2005-01-07_, INTERVAL 24 HOUR) > > However is there a simpler way of doing it by just passing one date like > > Select * from <TABLE> where date = _2005-01-07_
you may also go for "... WHERE year(foo)=a AND month(foo)=b AND dayofmonth(foo)=c;" t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]