"Paul Lautman" <paul.lautman@btinternet.com> wrote in message
news:5p5r0uFpgjp6U1@mid.individual.net...
> Summercool wrote:
>> in SQL, i wonder if I do a
>>
>>
>> select * from tablefoo where add_date = "2007-11-01"
>>
>>
>> then it may not show any record as it will only match recorded added
>> exactly at 2007-11-01 00:00:00
> Only if add_date is a DATETIME or TIMESTAMP type of field as oposed to a
> DATE type.
>
>

Many possibilities...

I always add a indexed DateID column that holds a FK to my Dates table. An
integer lookup will always be faster.

or

You could add (and index) a column that holds only the date portion of the
datetime field. There are many ways to truncate the time portion, I use
convert(datetime,convert(varchar(50),add_date,101) )

or

You could use ...BETWEEN '2007-11-01' AND '2007-11-02'