Might want to try date BETWEEN '01/4/2000' AND '01/5/2000' as well, this
is probably optimized better (although I may be wrong.)
At 11:41 AM 4/26/00, Martijn van Oosterhout wrote:
>Andras Balogh wrote:
> > So i am looking a date type that would allow me to do the following
> with one
> > (or a few) query
> > (and to be fast too):
> > -select all records for a given month
> > -select the count of records where the hour is 14.
> > -select all the records from the 7th week.
> > -select count of records where the day of the week is Sunday.
> > etc.
>
>How about you write your queries like:
>
>date >= '01/4/2000' and date < '01/5/2000'
>
>or equivalent. It allows use of the index but works the same.
>Except for the day is Sunday though...
>--
>Martijn van Oosterhout <kleptog@cupid.suninternet.com>
>http://cupid.suninternet.com/~kleptog/