Hi.
On Fri 2002-07-26 at 08:34:51 -0400, [EMAIL PROTECTED] wrote:
[...]
> set the dates up as DATETIME fields. However, indexing on these forces me to
> specify a date and time or a range. i.e.
>
> where ReceivedDate = '2002-07-26 08:15:05'
>
> or
>
> where ReceivedDate >= '2002-07-26' and Rec
I have just begun "playing around" with MySQL and I have a question about
indexing on dates.
Part of our system is a work flow management system and we have a table for
all documents that we receive. Each document record has several dates to
indicate when various processing functions have been co