1.年份
STUFF(convert(nvarchar(23),被替换字段,120),1,4,年份)
eg:
update SafeQuestionRecord
set CreateDate= STUFF(convert(nvarchar(23),CreateDate,120),1,4,SUBSTRING(Remark,1,4))
2.月份
STUFF(convert(nvarchar(23),被替换字段,120),6,2,月份)
eg:
update SafeQuestionRecord
set CreateDate= STUFF(convert(nvarchar(23),CreateDate,120),6,2,SUBSTRING(Remark,5,2))
3.日期
STUFF(convert(nvarchar(23),被替换字段,120),9,2,日期)
update SafeQuestionRecord
set CreateDate= STUFF(convert(nvarchar(23),CreateDate,120),9,2,SUBSTRING(Remark,7,2))
4.小时
STUFF(convert(nvarchar(23),被替换字段,120),12,2,小时数)
5.分钟
STUFF(convert(nvarchar(23),被替换字段,120),15,2,分数)
6.秒钟
STUFF(convert(nvarchar(23),被替换字段120),18,2,秒数)