Mybatis 时间比较 局部代码

数据库时间类型 ：datetime
Java Date类型

<if test="vo.activityState =='AF047001'">
	<![CDATA[  AND DATE_FORMAT( CURRENT_TIMESTAMP, '%Y-%m-%d %H:%T:%s' ) < DATE_FORMAT( start_time, '%Y-%m-%d %H:%T:%s' )   ]]>
</if>

<if test="vo.activityState =='AF047002'">
	<![CDATA[  AND DATE_FORMAT( CURRENT_TIMESTAMP, '%Y-%m-%d %H:%T:%s' )>DATE_FORMAT( start_time, '%Y-%m-%d %H:%T:%s' )
			AND DATE_FORMAT( CURRENT_TIMESTAMP, '%Y-%m-%d %H:%T:%s' ) < DATE_FORMAT( end_time, '%Y-%m-%d %H:%T:%s' )   ]]>
</if>

<if test="vo.activityState =='AF047003'">
	<![CDATA[  AND DATE_FORMAT( end_time, '%Y-%m-%d %H:%T:%s' ) < DATE_FORMAT( CURRENT_TIMESTAMP, '%Y-%m-%d %H:%T:%s' )   ]]>
</if>