> Currently, i am using this:You should use> CONVERT(DATETIME, '2003-06-29 00:00:00', 102) And CONVERT
> (DATETIME, '2003-07-05 00:00:00', 102)
dateColumn >= '20030629' AND dateColumn < '20030706'
(You don't need to convert a date to datetime, the query will do that for
you... and it makes your clause much easier to read.)
To see why I avoid the BETWEEN clause for dates:
There is at least a cheat sheet you can build on your own system:> date and not the time? Also, what is the meaning behind
> the number 102 and where can i get more information
> regarding this?
Also see this function, for developing a more intuitive function for date