select replace(convert(varchar(10),日期字段,120),'-0','-') from tb 转载于:https://www.cnblogs.com/moonvan/archive/2006/06/11/422960.html