Subject Date calculations
Author Riho-Rene Ellermaa
I have a problem that appears only in very rare cases, but it appears...

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

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

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

I try to change the 'now' to 'today' and hope this helps, but the question
remains - what's the reason?

Riho-Rene Ellermaa
senior programmer