select CONVERT(varchar(100), odate, 23) from tblOutStock 转载于:https://www.cnblogs.com/mingfeng/archive/2010/01/15/1648655.html