Subject | Re: [firebird-support] Simple SELECT statement not working Firebird-2.5.0.26083-0_Win32 |
---|---|
Author | Kjell Rilbe |
Post date | 2010-09-16T09:02:48Z |
LtColRDSChauhan skriver:
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
> On Thu, Sep 16, 2010 at 1:55 AM, Ivan Prenosil<Ivan.Prenosil@...>wrote:But Ivan asked you to try BETWEEN. Read his text again, carefully and
>> 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.
>
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