Sign in
Microsoft.com
 
Microsoft
 
 
 

none
SQL query

 > 

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    |