Sorry for the (hopefully) easy-to-answer question, I am really new to SQL and haven't successfully been able to figure this one out yet!
The scenario is:
We have a datetime column (stat_date_time_resolved) and I am trying to grab the value in that column and convert it to a varchar value in a separate column (resolved month).
stat_date_time_resolved = 2022-01-24 18:11:33.863
created month would = (1) January
stat_date_time_resolved = 2022-04-13 04:33:11.732
created month would = (4) April
I need to update all records in our table with these month values. Can anyone start me off in the right direction please?