--- 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