Hi everyone,
Post edited & changed:
How could I copy a column into another in a same table while changing the data type meaning that I want to convert a text to date format;
I tried several thing including convert function but it s always the error message :
unable to convert str to date.
Let s imagine a TABLE named DATE_TABLE
2 columns Date (type date) (empty) and Date_text (varchar) full of dd/mm/yyy text date.
What could be the script on azure sql to copy the date_text into the date column after converting it into date format?
Thanks for your help.
KR