mybatis时间段查询（sql）

  <sql id="selectWhere" >
       <where>
          1=1
                  <if test="beginDate !=  null  and beginDate != ''">
                         and       action_terminal.begin_Date&gt;=STR_TO_DATE(#{beginDate},'%Y-%m-%d %H:%i:%s')
                  </if>
                       <if test="endDate !=  null  and  endDate != ''">
                         and     action_terminal.end_Date &lt;= STR_TO_DATE(#{endDate},'%Y-%m-%d %H:%i:%s')  
                  </if>
                    <if test="terminalName !=  null  and  terminalName != ''">
                         like      action_terminal.terminal_name=#{terminalName,jdbcType=TIMESTAMP} 

                  </if>
       </where>
  </sql>

easyui datagrid 得到后台的时间数据是 jun 1,2016… 类似这样的时间

解决办法如下
前提要求是。实体BEEN 里面的时间类型是String
date_format(creation_date,'%Y-%m-%d %T') as creation_date,