create function getDateFromID(@id char(15))returns datetimeasbegindeclare @birthPart char(6);set @birthPart = substring(@id,7,6);declare @year int;set @year = cast(left(@birthPart,2) as int);if @year < 10 SET @year = 2000 + @year;elseSET @year = 1900 + @year;declare @birthday datetime;set @birthday = cast(cast(@year as char(4)) + ‘-‘ + substring(@birthpart,3,2) + ‘-‘+ substring(@birthpart,6,2) as datetime)return @birthdayendGOdeclare @id char(16)set @id = ‘510106830328511‘;print dbo.getDateFromID(@id)