I have a column in one of my tables called ‘Date’ and the Datatype is NVARCHAR(100). this column shows the date like 15/01/2024. this date is simple and I have many rows with different dates.
First I need to change the date format to 2024-01-15 or 2024/01/15
after that, I want to change the Datatype of the column to date.
New contributor
Soroush is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.