convert(date,A.CreateTime) >= convert(date,B.CreateTime) 转载于:https://www.cnblogs.com/Anthony518/p/10908154.html