条件如下: convert(date,a.dtClock) = convert(date,b.dtClock) 转载于:https://www.cnblogs.com/wlming/p/5796522.html