--- In firebird-support@yahoogroups.com, "Sergio H. Gonzalez" <shg_sistemas@...> wrote:

>
> Hello! I have a timestamp field with an index
>
> how can I select the fields from a given date, but using the index?
>
> If I do:
>
> where
> ((cast (MyTimeStamp as date)) between :from_date and :to_date)
>
> I guess that is better not to do the cast and pass the params with date
> + time.
>
> I use Delphi and I don't know how to add the time to the date in order
> to pass the parameter to the query...
>
> I'm trying with (to get all records from Feb 2nd)
>
> 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
>
> Thanks!!!!
>
> -s
>

Hi Sergio,

I always use dd-mmm-yyyy to avoid any ambiguity:

Therefore:
between '01-Feb-2012 00:00:00' and '01-Feb-2012 23:59:59'

Tom