var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Conversion from timestamp to date and vice-versa in pointbase
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