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]
