SELECT SUBSTRING(CONVERT(varchar(100),时间字段, 22),0,15) AS aa FROM 表名 转载于:https://www.cnblogs.com/lqLove/p/5964667.html