Скачать или смотреть How to extract part of a number in Microsoft SQL Server, and how to convert it into a date

How do you get just part of a number? What if it were a string?
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
Let's suppose that you have a number which represents a year and a month - for example:
DECLARE @Field INT = 202306
How could you extract the 2023 (year) and the 6 (month) separately?
Would it be any different if you had:
DECLARE @Field DECIMAL(8,2) = 202306
What about if you had?
DECLARE @Field VARCHAR(10) = '202306'
Finally, what if you wanted to turn it into a date?