date_format()的使用

最新推荐文章于 2024-12-19 19:05:27 发布

zj23qq

最新推荐文章于 2024-12-19 19:05:27 发布

阅读量1.1k

点赞数

分类专栏： Database

本文链接：https://blog.csdn.net/zj23qq/article/details/48712531

版权

Database 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

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');";