This forum is closed. Thank you for your contributions.
You can use the CONVERT function with argument 101:
select convert(datetime, '12/31/2016 01:03:03PM', 101)
Since you asked in the Training and Certification forum, this is covered in course 20461C "Querying Microsoft SQL Server".