将字符串日期格式转成日期格式 分别取出年月日时分

--修改mac表中日期为统一格式
declare @editdate varchar(50)
declare @idd int
declare @year varchar(50)
declare @month varchar(50)
declare @day varchar(50)
declare @hour varchar(50)
declare @minute varchar(50)
declare @mydate varchar(50)

declare mycur scroll Cursor for select idd,editdate from maccmd
for read only open mycur
fetch next from mycur into @idd,@editdate
while @@fetch_status=0
 begin
   set @year = (select datepart(yyyy,cast(editdate as smalldatetime)) from maccmd where idd=@idd )
   set @month = (select datepart(mm,cast(editdate as smalldatetime)) from maccmd where idd=@idd )
   set @day = (select datepart(dd,cast(editdate as smalldatetime)) from maccmd where idd=@idd )
   set @hour = (select datepart(hh,cast(editdate as smalldatetime)) from maccmd where idd=@idd )
   set @minute = (select datepart(mi,cast(editdate as smalldatetime)) from maccmd where idd=@idd )

   if len(@month)=1
 set @month='0'+@month
   if len(@day)=1
 set @day='0'+@day
   if len(@hour)=1
 set @hour='0'+@hour
   if len(@minute)=1
  set @minute='0'+@minute

   set @mydate=@year+'-'+@month+'-'+@day+' '+@hour+':'+@minute+':00'
   update maccmd set editdate=@mydate  where idd=@idd
   fetch next from mycur into @idd,@editdate
 end
close mycur
deallocate mycur