select convert(varchar(12), getdate(), 111) 转载于:https://www.cnblogs.com/epaib/archive/2005/12/06/291457.html