View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 11:29 AM
J.O. Aho
 
Posts: n/a
Default 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
Reply With Quote