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!

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 5 mths agoLast active
  • 19Views
  • 1 Following