Re: Date query optimization

[Karl J. Stubsjoen]

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