81,090
社区成员
发帖
与我相关
我的任务
分享
create table test (a varchar(20) )
go
insert test values ('130455721010003')
insert test values ('130455197211100013')
insert test values ('124235197301110034')
go
alter table test add b as convert(datetime,case when len(a)=18 then substring(a,7,8) else '19'+substring(a,7,6) end,120)
go
select * from test
declare @Birtyday smalldatetime
set @Birtyday ='2010-01-20'
--set @Birtyday =getdate()
select datediff(year,@Birtyday,getdate())
- case when datediff(day,dateadd(year,datediff(year,@Birtyday,getdate()),@Birtyday),getdate()) >= 0 then 0
else 1 end
select case length(idcode) when 15 then '19'+substr(idcode,6,2) when 18 then substr(idcode,6,4) end