This is not asking how to convert an arbitrary string to datetime in MSSQL such as this question. ... ...
stackoverflow.com