select substring(convert(char,Garrison_Date,120),1,10) as Garrison_Date from aDoor 可将 2008-11-5 0:00:00 截取成2008-11-5