34,837
社区成员




declare @s as varchar(20)
set @s = 'abc070805'
select result =
right(datename(year,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
+ right('00'+datename(mm,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
+ right('00'+datename(day,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
/*
result
--------------------------------------------------------------------
090805
(1 行受影响)
*/
declare @s as varchar(20)
set @s = 'abc070805'
select result = left(@s,3) +
right(datename(year,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
+ right('00'+datename(mm,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
+ right('00'+datename(day,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
/*
result
--------------------------------------------------------------------
abc090805
(1 行受影响)
*/
declare @s as varchar(20)
set @s = 'abc070805'
select result = left(@s,3) +
right(datename(year,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
+ right('00'+datename(mm,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
+ right('00'+datename(day,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
/*
result
--------------------------------------------------------------------
abc09085
(1 行受影响)
*/
declare @s as varchar(20)
set @s = 'abc070805'
select result = left(@s,3) +
right(datename(year,(dateadd(year,2,cast(right(@s,6) as datetime)))),2)
+ datename(mm,(dateadd(year,2,cast(right(@s,6) as datetime))))
+ datename(day,(dateadd(year,2,cast(right(@s,6) as datetime))))
/*
result
--------------------------------------------------------------------
abc09085
(1 行受影响)
*/