oracle？SqlServer？mysql？
---------
with a as (
select '2401111245' [t]
union all
select '8305120715'
)
select *,(CASE WHEN LEFT(T,2)*1>RIGHT(YEAR(GETDATE()),2) THEN '19'+LEFT(T,2) ELSE '20'+LEFT(T,2) END)+'-'+SUBSTRING(T,3,2)+'-'+SUBSTRING(T,5,2)+' '+SUBSTRING(T,7,2)+':'+RIGHT(T,2)+':00' [date_] from a
1min目标场景问卷
立即参与
