Splitting a column in SQL

Hi so im looking to split a date at the ‘/’ marker in the date column. the date column is a nvarchar(255) from a excel file so I havent found many solutions to work. here is my code so far

SELECT TOP (1000)
           [Date]
          ,[month]
      FROM [UpdatedSteph].[dbo].['Stephen Curry Regularseason Sta$']

  

    select date,
    	case when date = '1' then 'January'
    	     when date = '2' then 'February'
    		 when date = '3' then 'March'
    	     when date = '4' then 'April'
    		 when date = '5' then 'May'
    	     when date = '6' then 'June'
    		 when date = '7' then 'July'
    	     when date = '8' then 'August'
    		 when date = '9' then 'September'
    		 when date = '10' then 'October'
    		 when date = '11' then 'November'
    		 when date = '12' then 'December'
    		 else 'null'
             end
             from UpdatedSteph..['Stephen Curry Regularseason Sta$']

ive tried using the string_split but wasnt sure if i was putting it in the wrong place or not. The reason i am looking to split is because i want my case statement to grab the first number which is the month is the date column, and turn those into the listed month in order to break down the statistics to a monthly average.

Have you tried using EXTRACT() ? or DATEPART to grab the month?

ex:

SELECT EXTRACT(
    MONTH FROM TIMESTAMP '2016-12-16 07:50:35'
    ) AS "Month";

Or, can you maybe clean it up in Excel first then import it to your SQL table?

it is not recognized as a timestamp because it wasnt set up as a datetime in excel very well. its in the format of MM/DD. right now its a nvarchar. ive been thinking of ways to change it in excel but there are over 700 rows and trying to change anything in the date column with a 1 will not only change january, but also oct, nov, and dec

Did you try DATEPART ? Would that work?