I have a column called “Month Year Raw” that has multiple nvarchar type data like this: 202201 and I want to convert that to a column called “Month Year” that will be like “January 2022”.

CodePudding user response：

This is really bad news. You shouldn't be storing dates as strings at all, never mind multiple times (which is just redundant storage for no gain). Even nvarchar is bad; why would you ever need to use Unicode characters to represent yyyyMM? I know 2020 was bad but you still can't use 4 poop emojis (