Hi,
My Name is Wangminhao Gou,I hava used calcite to operate several relational 
databases including PG,however,when I want to insert timestamp value,there is 
an exception.The information is like this:
org.apache.calcite.runtime.CalciteContextException: From line 1, column 47 to 
line 1, column 60: Cannot assign to target field 'plt_createtime' of type 
TIMESTAMP(3) from source field 'EXPR$1' of type CHAR(23)
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign 
to target field 'plt_createtime' of type TIMESTAMP(3) from source field 
'EXPR$1' of type CHAR(23)
however when I used the same SQL statement in the navicat towards the PG,it 
succeeds.
What should I do then?Thank you.


Sincerely,
Wangminhao Gou

Reply via email to