Subject Re: [IBO] Date calculations
Author Luiz Alves
On this type of query I generally use:

WHERE docdate<cast('today' as date)+1


WHERE docdate<(current_date +1)


----- Original Message -----
From: Riho-Rene Ellermaa <r.ellermaa@...>
To: IBObject (E-mail) <>
Sent: Friday, June 22, 2001 5:31 AM
Subject: [IBO] Date calculations

> 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
> 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.
> todays records are not selected.
> When I look my table with some Interbase tool, then I see field values
> 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
> Your use of Yahoo! Groups is subject to