--- In ib-support@y..., Bob Murdoch <ram5@e...> wrote:

> This is a dialect 1 database. Del_date is based on a domain which

was

> declared as 'CREATE DOMAIN D_DATE AS DATE;'.

Bob, long ago I encountered in IB4 that '=' for date columns seldom
but can don't see match even if timestamp is stored with date part
only. I could'nt define conditions for this case, seems it appears
only when query is made on client but works within SP. So I think it
is difference between char to date (double) casting subroutines in IB
server and host language - Delphi, C and so on. Apparently rounding
subroutines are different - Delphi's, for example, uses FISTP
instruction and supports Western rounding rules but IB/FB internal
supports more habit for us in Russia rules. Perhaps difference in
client and server char-data convertion has similar source.

Best regards, Alexander V.Nevsky.