Hi there,
We currently have a table column where the datatype is NVARCHAR(15), which is used to store a date in the format 16/04/2021. We would like to be able to change that format of the existing rows in the table to 20210416.
Is this possible?
Any guidance would be appreciated
Thank you