日期字段筛选

遇到个小问题，日期删选时报错：
.w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.http.converter.HttpMessageNotReadableException: JSON parse error: Invalid UTF-8 start byte 0xa0; nested exception is com.fasterxml.jackson.core.JsonParseException: Invalid UTF-8 start byte 0xa0 at [Source: (PushbackInputStream); line: 1, column: 12]]

后面检查发现是参数问题，原来是实体类参数signDate不包含startDate和endDate，然后修改，
最后测试：

实体类：

   @Basic
    @Column(name = "sign_date")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")

处理前端传入参数的临时字段

包含sql筛选查询

       <if test="timeStart != null">
            and ct.valid_date >= to_timestamp(#{timeStart},'yyyy-MM-dd hh24:mi:ss')
        </if>
        <if test="timeEnd != null">
            and ct.valid_date &lt;= to_timestamp(#{timeEnd},'yyyy-MM-dd hh24:mi:ss')
        </if>
        <if test="signDate != null">
            <if test="signDate.startDate != null">
                and ct.sign_date >= to_timestamp(#{signDate.startDate},'yyyy-MM-dd hh24:mi:ss')
            </if>
            <if test="signDate.endDate != null">
                and ct.sign_date &lt;= to_timestamp(#{signDate.endDate},'yyyy-MM-dd hh24:mi:ss')
            </if>

        </if>