framework/resources/Functional/joins/implicit_cast/on_c_timestamp_and_c_date.sql

select count(*) from cast_tbl_1 a, cast_tbl_2 b where a.c_timestamp = b.c_date;