Subject | Error in conversion in between clause |
---|---|
Author | Roberto Carlos |
Post date | 2008-11-10T02:08:56Z |
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?
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?