DECLARE @dt varchar(100) declare @a datetime SET @dt='05 24 2006' set @a=replace(@dt,' ','/') SELECT convert(varchar(10),replace(CONVERT(char(10),@a,111),'/','-')) 结果就是 2006-05-24 而且是字符串格式
將'05 24 2006'這個換成sql,用循環的方式
create table a (dt varchar(100))insert a values ('05 24 2006') insert a values ('05 22 2006') insert a values ('04 24 2003') insert a values ('06 24 2006')SELECT SUBSTRING(a.dt,7,4)+'-'+SUBSTRING(a.dt,1,2)+'-'+SUBSTRING(a.dt,4,2) from a
declare @a datetime
SET @dt='05 24 2006'
set @a=replace(@dt,' ','/')
SELECT convert(varchar(10),replace(CONVERT(char(10),@a,111),'/','-'))
结果就是 2006-05-24 而且是字符串格式
(dt varchar(100))insert a values ('05 24 2006')
insert a values ('05 22 2006')
insert a values ('04 24 2003')
insert a values ('06 24 2006')SELECT SUBSTRING(a.dt,7,4)+'-'+SUBSTRING(a.dt,1,2)+'-'+SUBSTRING(a.dt,4,2) from a