Subject Re: [IBO] Date calculations
Author Lele Gaifax
>>>>> On Fri, 22 Jun 2001 10:31:31 +0200, "Riho-Rene Ellermaa" <r.ellermaa@...> said:

RE> Hi! I have a problem that appears only in very rare cases,
RE> but it appears...

RE> 'Docdate' is a Timestamp field. I default it to "now". The
RE> column properties are set to NO TIME.

RE> In other query I have: WHERE docdate<='today'

RE> In most cases this works, but 1...5 customers are having
RE> problems - i.e. the todays records are not selected. When I
RE> look my table with some Interbase tool, then I see field
RE> values only as 22.06.2001, without time part as it should be.

IB seems to understand the query in a different way, when dealing with
timestamps. Infact, only a timestamp like "2001/06/22 00:00:00" pass
that "<=" comparison operator...

I use something like "WHERE docdate < ('TODAY'+1)" to get similar

bye, lele.
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.