Creating new "month" column from an existing datetime column
I have an existing column in a table that is 'datetime' type. Specifically "yyyy-mm-dd 00:00:00". I would like to create a column that returns the month name based on the existing column values. So for a cell "1999-01-07 00:00:00" where the month is 01, the new column would return a cell for that row that reads "January". Same for February for 02, and so on.
Thanks in advance!