Returns an integer from a 'date' string based on the argument of datepart abbreviation.

DATEPART ( datepart , date )

References:

• https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql