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 [Non-text portions of this message have been removed]