Question:
The same SQL statement can be executed normally in Oracle, but an error will be reported in the mybatis framework: ora-01722: invalid number or string does not match the data type
solve
Convert variable to string type:
g.UPDATETIME >= TO_CHAR(TRUNC (SYSDATE))，
g.CHECKDATE >= TO_CHAR('2021-01-01 00:00:00'))Read More:
- How to Solve mybatis returns null when querying Oracle database with char type field
- When the mybatis field contains an expression, an error is reported when it is stored in the database
- Error attempting to get column ‘xxxxx’ from result set — after Lombok is annotated with builder, mybatis cannot recognize the correct type of field
- Solution of error converting data type varchar to datetime in SQL Server
- Type definition error – one of the causes of type definition errors is WM in Oracle_ Concat function usage
- Oracle reports an error and lsnrctl listening cannot be started
- Converting string object into datetime type in pandas
- Error converting data type nvarchar to datetime
- On the usage of ‘ref.stor.type search’ field in SAP WM movement type
- The java.lang.exceptionininitializererror of mybatis reports an error
- Two ways of fuzzy query in mybatis
- Redis reports an error when integrating springsecurity: could not read JSON: unrecognized field “enabled”“
- Mybatis uses step-by-step lazy loading to cause abnormal JSON conversion. The interface 500 reports an error
- How can Oracle query tables of other users without adding a table user name
- An error related to field none type occurs when allennlp executes the train
- Failed to create Oracle Oracle home user solution appears in oracle12c installation
- Lamdba in the studio part reports an error. Observe lamdba reports an error but can run
- Arithmetical overflow error converting expression to data type datetime
- Ie8.0 reports Oracle error 1403 error after logging into Oracle EBS
- Arduino reports an error when writing a custom library file to solve the problem of not name of type, not declared in this scope