You can use
CAST or CONVERT function[
^].
SELECT CONVERT(DATETIME, '10/16/2014 10:20:20 PM') AS MyDateTime
In case of convertion failed because of 'out of range' error message, use
SET DATETIMEFORMAT command[
^].
SET DATETIMEFORMAT mdy;
SELECT CONVERT(DATETIME, '10/16/2014 10:20:20 PM') AS MyDateTime