Use t-SQL to extract the birthday from the ID card number from others and use it for personal learning and favorites)

Use t-SQL to extract the birthday from the ID card number. The following is an example of converting the 15-digit ID card number for your reference only. Create function getDateFromID (
@ Id char (15)
)
Returns datetime
As
Begin
Declare @ 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;
Else
SET @ year = 1900 + @ year;

Declare @ birthday datetime;
Set @ birthday = cast (@ year as char (4) + '-'
+ Substring (@ birthpart, 3, 2) + '-'
+ Substring (@ birthpart, 6, 2) as datetime)
Return @ birthday
End
GO
Declare @ id char (15)
Set @ id = '000000 ';
Print dbo. getDateFromID (@ id)