Declare @Dt DateTime
Set @Dt='2006-05-26 15:43:33.840'
Select Convert(Varchar(10),@Dt,120)
--Result
2006-05-26
转载于:https://www.cnblogs.com/oop/archive/2006/05/26/410067.html
转载于:https://www.cnblogs.com/oop/archive/2006/05/26/410067.html