--截取,月份
select cast(cast (substring(cast(GETDATE()as varchar),6,2) as int)as varchar)
修改为:
select cast(cast(DATENAME(MONTH,GETDATE()) as int)as varchar)
--截取,月份
select cast(cast (substring(cast(GETDATE()as varchar),6,2) as int)as varchar)
修改为:
select cast(cast(DATENAME(MONTH,GETDATE()) as int)as varchar)