34,576
社区成员
发帖
与我相关
我的任务
分享
update tb set 出生年月= dateadd(year,1,cast(left(出生年月,4)+'-'+substring(出生年月,5,2)+'-'+'01' as datetime))
update 出生年月= dateadd(year,1,cast(left(出生年月,4)+'-'+substring(出生年月,5,2)+'-'+'01' as datetime))
update userinfo set 领证日期 = dateadd(year,convert(datetime,substring(出生年月,1,4)+'-'+substring(出生年月,5,2)+'-01',120)
update userinfo set 领证日期=convert(varchar(10),dateadd(year,1,cast(LEFT(领证日期,4)+'-'+RIGHT(领证日期,2)+'-01' as DATE)),23)