Mysql,mybatis problems encountered in the use of the type conversion

The reason is not clear, first record.

Use the DateDiff function to calculate a time difference of two dates. In MyBatis, Resulttype is a map. In the code, depending on the value of the map key.

In MySQL 5.5.39, the resulting type is an integer

In MySQL 5.6.11, the resulting type is long

The current solution is the value that map takes out and is converted uniformly into a string. Convert as needed. The cause is not yet clear. Just record it.

Mysql,mybatis problems encountered in the use of the type conversion