Subject | Re: [IBO] Date arithmetics |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-04-03T07:52Z |
Thanks Luiz,
wonder why I didn't think of that simple solution before I wrote that
stored procedure circumventing the problem. I didn't actually try your
solution using <= and >=, but did the same using BETWEEN and it works just
fine.
Still, I do wonder why IBO (or Firebird) insists on subtracting a date
parameter rather than an integer parameter from another date when comparing
to a third date. I guess it isn't important to know for the future now that
we have your solution to such a problem.
Set
At 17:18 02.04.2003 -0300, you wrote:
wonder why I didn't think of that simple solution before I wrote that
stored procedure circumventing the problem. I didn't actually try your
solution using <= and >=, but did the same using BETWEEN and it works just
fine.
Still, I do wonder why IBO (or Firebird) insists on subtracting a date
parameter rather than an integer parameter from another date when comparing
to a third date. I guess it isn't important to know for the future now that
we have your solution to such a problem.
Set
At 17:18 02.04.2003 -0300, you wrote:
>You could try:
>
>SELECT AColumn
>FROM ATable
>WHERE Date2 - Date1<= :OneInteger AND Date2-Date1>= :AnotherInteger