mysql 计算两个日期的天数
update jk_his_zybrcryxxb set xse='是',nldw='天' where id in
(
select id FROM
(
select id from jk_his_zybrcryxxb where DATEDIFF( ryrq,csrq )<=28) a
)
posted on 2022-06-16 08:08 zyp_java_net 阅读(164) 评论(0) 编辑 收藏 举报
update jk_his_zybrcryxxb set xse='是',nldw='天' where id in
(
select id FROM
(
select id from jk_his_zybrcryxxb where DATEDIFF( ryrq,csrq )<=28) a
)
posted on 2022-06-16 08:08 zyp_java_net 阅读(164) 评论(0) 编辑 收藏 举报