How to change only label in MS SQL?

Question

SQL Server

Hi all!
is in the date table, but the text type.

We need to change the words to numbers.
For example: if 02-May-13 should be 02-05-13.
Help how to update?

Answer 1

https://msdn.microsoft.com/ru-ru/library/ms187928.aspx
specifically convert
Well, bloody tears in the case when suddenly there are different spellings of dates in the column...
p/s/ I would try to refactor the table as quickly as possible converting date to date

Answer 2

Definitely refactor. For now it is possible and through replace.