- <select id="GetList" resultType="java.util.Map" parameterType="com.xy.cc.bean.ComputeParam">
- SELECT `id`, `no`, `SerialNum`, `date_of_occurrence`, `time_frame`, `interval_month`,
- `birthday`, `sex`, `weight`, `nation`, `height`, `city_a`, `human_race`,
- `untoward_reaction_name`, `level`, `new_or_old`, `table` FROM xy_survey_compute
- WHERE SerialNum=#{SerialNum} and company_id=#{company_id} AND STR_TO_DATE(`date_of_occurrence`,'%Y-%m-%d
- %H:%i:%s') >= STR_TO_DATE(CONCAT(#{start_date},'00:00:01'),'%Y-%m-%d %H:%i:%s')
- AND STR_TO_DATE(`date_of_occurrence`,'%Y-%m-%d %H:%i:%s')
- <=STR_TO_DATE(CONCAT(#{end_date}, '23:59:59'), '%Y-%m-%d %H:%i:%s') </select>
来源: http://www.bubuko.com/infodetail-3358931.html