select convert(varchar(100),convert(smalldatetime,CHECK_DATE),111) CHECK_DATE
FROM VI_IM40_1
转载于:https://www.cnblogs.com/pfcan66/archive/2012/03/16/2399881.html
select convert(varchar(100),convert(smalldatetime,CHECK_DATE),111) CHECK_DATE
FROM VI_IM40_1
转载于:https://www.cnblogs.com/pfcan66/archive/2012/03/16/2399881.html