Subject Error in conversion in between clause
Author Roberto Carlos
The following select worked on FB 1.5.5, however on FB 2.1.1 it raises exception "Unsupported field type specified in BETWEEN predicate", but A.Arrival and S.Arrival are timestamp fields:

Select A.ID From Cars A
Where
 A.Situation = 'A' and
 (
   Cast(A.Arrival as Date) between '01.10.2008' and '30.10.2008'
 or
   (Select Min(Cast(S.Arrival as Date)) From History S
    Where S.Car_ID = A.ID) between '01.10.2008' and '30.10.2008';
 );

Why this error?