Re: getting records for 1 day

Summercool wrote:
> in SQL, i wonder if I do a
>
>
> select * from tablefoo where add_date = "2007-11-01"

this works for mysql:
SELECT * FROM tablefoo WHERE add_date>20071101 AND add_date<20071102

-- 

  //Aho