mikcaau wrote:

>>
>>(`WORK_DATE' is a TIMESTAMP field) it gives the error:
>>
> SELECT WORK_DATE FROM OBJECTS_IN_WORK
> WHERE WORK_DATE between '12-may-2005' AND '14-apr-2005'
>
> In a dialect 3 database this will NOT return rows where work_date is
> on 14-apr-2005.

Ah. If you asked for a scaled number between 1 and 5, you wouldn't
expect to get 5.1, would you? This is the same case.


Regards,


Ann