On 1 Jul 2003 at 10:28, Karl J. Stubsjoen wrote: > > The normal way to do a search for a range of dates would be > > > > ... WHERE a.submitdate BETWEEN '2003-07-01' AND '2003-07-14'; > > > > Is that what you're looking for? > > submitdate happens to be a DATETIME field. > Your suggested query doesn't pull any results.
If it's a DATETIME field, you'll want something like ... WHERE a.submitdate BETWEEN '2003-07-01 00:00:00' AND '2003-07-14 23:59:59'; or ... WHERE a.submitdate >= '2003-07-01 00:00:00' AND a.submitdate < '2003-07-15 00:00:00'; -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]