framework/resources/Functional/joins/explicit_cast/on_c_date_and_c_timestamp.sql

select count(*) from cast_tbl_1 a INNER JOIN cast_tbl_2 b ON (a.c_integer = b.c_integer AND CAST(a.c_date as TIMESTAMP) < b.c_timestamp);