hi experts,
According to this doc https://calcite.apache.org/docs/reference.html the
EXTRACT function should work in Calcite. So I'm trying a query with EXTRACT
in CSVTest:
@Test public void testSelectx() throws SQLException {
checkSql("model", "select extract(year from JOINEDAT) from EMPS ");
}
the query failed due to:
java.lang.ClassCastException: java.sql.Date cannot be cast to
java.lang.Integer
I also tried to change column JOINDAT's type to timestamp and datetime, but
end up with similar exceptions.
Can you please help here? thx
--
Regards,
*Bin Mahone | 马洪宾*
