select DATEADD(dd,DATEDIFF(dd,0,getdate()),0) 转载于:https://www.cnblogs.com/190196539/archive/2011/10/30/2229223.html