Svein Erling Tysvær wrote: > > you can miss some records from the last second (let's say 02-01-2012 > 23:59:59.1234).
How "exact" is a Firebird timestamp at all, and could I use fractions of a second in a query? For example where MyTimeStamp between '02-01-2012 00:00:00.0000' and '03-01-2012 23:59:59.9999' instead of > where MyTimeStamp between '02-01-2012' and '03-01-2012' and cast(MyTimeStamp) > as Date = > '02-01-2012' > will get you all AND use an index (BETWEEN uses the index, CAST ascertains > you return the correct > rows). Or, would where MyTimeStamp>='02-01-2012' and MyTimeStamp<'03-01-2012' use the index? (I guess this would return the correct rows, too.) -Matt