Keith, > 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. Must I convert the field first? But then is my query unoptimized? Should I consider storing date parts into my database; seperate column for year - month - date and (time parts..) Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
