MySQL:select * from table where ctime >= CURDATE() and ctime <DATE_SUB(CURDATE(),INTERVAL -1 DAY); XML: <select id="selectByUidToday" parameterType="java.lang.Integer" resultMap="BaseResultMap"> select <include refid="Base_Column_List" /> from fc_temporarydanger_census_t where uid = #{uid,jdbcType=INTEGER} and ctime >= date(now()) and ctime < DATE_ADD(date(now()),INTERVAL 1 DAY) </select>