12 2021 档案

sql查询到期前多少天的订单数据
摘要：select * from my_product where product_type = 1 and status = 36 and TIMESTAMPDIFF(DAY, NOW(), date_add(eff_time, interval 30 day)) = #{days,jdbcType=I 阅读全文
posted @ 2021-12-17 10:52 红尘沙漏 阅读(88) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示