用游标给你写了一个declare @m char(2) declare @d char(2) declare @rq char(10) declare @y char(4)declare ctm cursor for select substring(value,1,4),substring(value,6,len(value)- charindex('-', REVERSE(value))-5), substring(value,len(value)- charindex('-', REVERSE(value))+2,2) from testtopen ctmfetch next from ctm into @y,@m,@d while (@@fetch_status=0) begin if (len(@m)=1 ) begin set @m = '0'+@m end if (len(@d)=1) begin set @d = '0'+@d end set @rq= @y+'-'+@m+'-'+@d print @rq update testt set value=@rq where current of ctm fetch next from ctm into @y,@m,@d end close ctm deallocate ctm
declare @d char(2)
declare @rq char(10)
declare @y char(4)declare ctm cursor
for
select substring(value,1,4),substring(value,6,len(value)- charindex('-', REVERSE(value))-5),
substring(value,len(value)- charindex('-', REVERSE(value))+2,2)
from testtopen ctmfetch next from ctm into @y,@m,@d
while (@@fetch_status=0)
begin
if (len(@m)=1 ) begin
set @m = '0'+@m
end
if (len(@d)=1) begin
set @d = '0'+@d
end
set @rq= @y+'-'+@m+'-'+@d
print @rq
update testt
set value=@rq where current of ctm
fetch next from ctm into @y,@m,@d
end
close ctm
deallocate ctm
以前的为:yyyy-m-d hh:mm:dd
以后的为:yyyy-mm-dd hh:mm:dd