Use T-SQL to extract birthdays from your Social Security number

Use T-SQL to extract a birthday from a social security number, which is an example of converting a 16-digit ID number, for informational purposes only.

Create functionGetdatefromid (@id Char( the))returns datetime asbeginDeclare @birthPart Char(6);Set @birthPart = substring(@id,7,6);Declare @year int;Set @year = cast( Left(@birthPart,2) as int);if @year < Ten SET @year =  - + @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( -)Set @id = '510106830328511';PrintDbo.getdatefromid (@id)

Use T-SQL to extract birthdays from your Social Security number