This is not asking how to convert an arbitrary string to datetime in MSSQL ... UPDATE MyTable SET MyDate = CONVERT(datetime, '2009/07/16 ...
stackoverflow.com