实践出真知你这样: select cast(year(@date) as varchar(4)) + '年'+ cast(month(@date) as varchar(2))+'月'+ cast(day(@date) as varchar(2)) +'日' union all select cast(year(@date) as varchar(4)) + '年'+ cast(month(@date) as varchar(2))+'月'+ cast(day(@date) as varchar(2)) +'日'
union all select cast(year(@date) as varchar(4)) + '年'+ cast(month(@date) as varchar(2))+'月'+ cast(day(@date) as varchar(2)) +'日' 100个 运行一下看看时间然后再 select stuff(stuff(stuff(convert(varchar(11),@dt,120),11,0,'日'),8,0,'月'),5,0,'年') union all select stuff(stuff(stuff(convert(varchar(11),@dt,120),11,0,'日'),8,0,'月'),5,0,'年')
union all select stuff(stuff(stuff(convert(varchar(11),@dt,120),11,0,'日'),8,0,'月'),5,0,'年') 也100个你自己比较吧
datepart(month,@date)+'月'+
datepart(day,@date) +'日'
datename(month,@date)+'月'+
datename(day,@date) +'日'
select cast(year(@date) as varchar(4)) + '年'+
cast(month(@date) as varchar(2))+'月'+
cast(day(@date) as varchar(2)) +'日'
union all
select cast(year(@date) as varchar(4)) + '年'+
cast(month(@date) as varchar(2))+'月'+
cast(day(@date) as varchar(2)) +'日'
union all
select cast(year(@date) as varchar(4)) + '年'+
cast(month(@date) as varchar(2))+'月'+
cast(day(@date) as varchar(2)) +'日'
100个
运行一下看看时间然后再
select stuff(stuff(stuff(convert(varchar(11),@dt,120),11,0,'日'),8,0,'月'),5,0,'年')
union all
select stuff(stuff(stuff(convert(varchar(11),@dt,120),11,0,'日'),8,0,'月'),5,0,'年')
union all
select stuff(stuff(stuff(convert(varchar(11),@dt,120),11,0,'日'),8,0,'月'),5,0,'年')
也100个你自己比较吧
cast效率稍稍好于stuff、stuff效率稍稍好于datename