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]

Reply via email to