date_format()的使用

String sql = " select * from tjyx.member a where  a.DELETED = 0 and DATE_FORMAT(a.BIRTH_DATE, '%m%d')>=DATE_FORMAT('";
sql = sql + start + "', '%m%d') and DATE_FORMAT(a.BIRTH_DATE,'%m%d')<= DATE_FORMAT('";
sql = sql +	end	+ "', '%m%d') and a.MEMBER_ID not in (select b.MEMBER_ID from tjyx.birth_remind_info b)";

String sql = "delete from tjyx.birth_remind_info where id>0 and DATE_FORMAT(birthday,'%m%d')<DATE_FORMAT('" 
<span style="white-space:pre">				</span>+ sdf.format(date) + "','%m%d');";