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.