SELECT
*
FROM
kit_order2 a
left join approval_user b on a.igenetech_linkman=b.user_name
WHERE
TIMESTAMPDIFF( DAY, NOW( ), a.estimated_delivery_time ) >= #{dataTime}
GROUP BY a.igenetech_linkman
mysql 时间差几天
最新推荐文章于 2024-09-08 11:26:17 发布