In article <[EMAIL PROTECTED]>, "Pete Moran" <[EMAIL PROTECTED]> writes:
> Hi All, > Is there a simpler way of doing a select for a given date, for instance if I > have a datetime field called date > And so its populated with a load of values such as > 2005-01-07 09:00 > 2005-01-07 10:00 > 2005-01-07 11:00 > 2005-01-07 12:00 > If I wanted all records which fall on 2005-01-07 I could of course do > 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 could use WHERE cast(date AS DATE) = '2005-01-07' but this would preclude using an index. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]