select convert(nvarchar(10),cast('2008-8-7' as datetime) ,120) select convert(nvarchar(10),cast(data as datetime) ,120)
update tb set 日期=convert(varchar(10),(cast(日期 as datetime)),120) where isdate(日期)=1
update tb set col=case when isdate(col)=1 then convert(varchar(10),cast (col as datetime),120) else col end update tb set col=convert(varchar(10),cast (col as datetime),120) where isdate(col)=1
update tb set 日期=convert(varchar(10),(cast(日期 as smalldatetime)),120) where isdate(日期)=1
直接改数据类类型为datetime就好了
select convert(nvarchar(10),cast(data as datetime) ,120)
set 日期=convert(varchar(10),(cast(日期 as datetime)),120)
where isdate(日期)=1
update tb set col=case when isdate(col)=1 then convert(varchar(10),cast (col as datetime),120) else col end
update tb set col=convert(varchar(10),cast (col as datetime),120)
where isdate(col)=1
set 日期=convert(varchar(10),(cast(日期 as smalldatetime)),120)
where isdate(日期)=1