none
SQL query

Answers

  • 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".

    Wednesday, July 6, 2016 5:32 AM