MyBatis SQL statement for datetime query in XML

<if test= "Startdate!=null and startdate!=" "> and CreateDate &gt; =#{startdate}</if>
<if test= "Enddate!=null and enddate!=" "> and CreateDate &lt; =#{enddate}</if>

Three date fields are stored in the database are strings, not date type, XML >,< cannot be parsed correctly, need XML escape character

One thing, although it is a string but does not need to be converted to ASCII value to compare size, I previously used ASCII (CreateDate) and ASCII (#{startdate}) to compare, does not work.

However, two strings can be compared directly to the size of the greater than and less than. Do not know the date format can be directly compared, try later, to be continued.

MyBatis SQL statement for datetime query in XML