I need to alter the data type of a existing column in a table (large table with a lot of data). The original data type is DATETIME.
Now, I want to change the data type to VARCHAR(50). Unfortunately, the result is not want I want, e.g. "Aug 8 2003 12:00AM". I want the result in the same format like datetime, e.g. "08/08/2003".
Is there any methods to convert the datatype to the desired format after the changes to the datatype?