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
My mistake!... that seems to work OK... Now I just wonder if that is the
*best* way to do that... So far
--- 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
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
My mistake!... that seems to work OK... Now I just wonder if that is the *best*
way to do that... So far I