Subject | Date calculations |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2001-06-22T08:31:31Z |
Hi!
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
Hansabank
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
Hansabank