1 CONVERT(Date, 时间字符串变量 ) between CONVERT(Date,'2015/2/10') and CONVERT(Date,'2015-3-10') 转载于:https://www.cnblogs.com/woloveprogram/p/4950217.html