<if test="beginDate!=null and beginDate!= '' ">
and CONVERT_TIM >=to_date(#{beginDate},'yyyy/mm/dd
hh24:mi')
</if>
<if test="endDate!=null and endDate !=''">
and CONVERT_TIM <=to_date(#{endDate},'yyyy/mm/dd hh24:mi')
</if>
and CONVERT_TIM >=to_date(#{beginDate},'yyyy/mm/dd
hh24:mi')
</if>
<if test="endDate!=null and endDate !=''">
and CONVERT_TIM <=to_date(#{endDate},'yyyy/mm/dd hh24:mi')
</if>