| Subject | Re: selecting between dates with timestamps fields |
|---|---|
| Author | Sergio |
| Post date | 2012-02-03T16:48:19Z |
> I'm trying with (to get all records from Feb 2nd)My mistake!... that seems to work OK... Now I just wonder if that is the *best* way to do that... So far I see no problem, but just in case...
>
> where
> (MyTimeStamp between '02-01-2012 00:00:00' and '02-01-2012 23:59:59')
>
> it uses the index, but I don't get all the records
-s