I have a query in pointbase which is as written below

select * from orientation_response where driver_id = 1 and response_date > (select active_date from driver_info where driver_id = 1);

On running this query i get an IllegalCastOperation betweem type: TIMESTAMP and typeATE.

Any idea as to how i can convert a TIMESTAMP to DATE in pointbase?

RESPONS_DATE is a TIMESTAMP type and ACTIVE_DATE is a DATE type