Subject Re: [firebird-support] Simple SELECT statement not working Firebird-2.5.0.26083-0_Win32
Author Kjell Rilbe
LtColRDSChauhan skriver:
> On Thu, Sep 16, 2010 at 1:55 AM, Ivan Prenosil<Ivan.Prenosil@...>wrote:
>> Are you sure the .674 is correct ? Timestamp's precision is 4 decimal
>> places after seconds.
>> Can you try
>> p.ENTRYTIME BETWEEN '15.9.2010, 20:40:06.6740' AND '15.9.2010,
>> 20:40:06.6749'
>> ?
>>
>> I did try '15.09.2010, 20:40:06.6740' , '15.9.2010, 20:40:06.674',
> '15.9.2010, 20:40:06.6740'. Thanks a lot.
>
But Ivan asked you to try BETWEEN. Read his text again, carefully and
try EXACTLY what he wrote.

It may not help to try various exact fractions. His point was for you to
try an interval, using between.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64