The second SELECT statement you posted will include dates from 2003-06-28. I
think you wanted just one day:
SELECT * FROM table WHERE date>='20030629' AND date<'20030630'
Always use ISO (YYYYMMDD) format for dates to avoid dependencies on regional
As you point out, other solutions to extract just the date portion of the
DATETIME will be slower because they cannot benefit from indexing on the
column. Above is the best method.
Please reply only to the newsgroup