At 05:01 PM 14/03/2003 -0300, you wrote:

>The result of DATE operations (-) is number of days in the interval, I
>do it all the time, with dialect 3.

So do I. I think Alexander must be thinking of some other problem, like
trying to subtract a timestamp from a date type, which does cause problems
if you don't cast the dates.

The problem here seems to be that the db engine is not correctly
interpreting a legal date literal as a date. Did you try the casting solution?

heLen