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编辑  收藏  举报

导航