The trouble with the time format update in SQL Server

Read from the client when time now inserts a Tatetime type field from the SQL Server table, the time format in the client's area design is T,TT, that is, the morning-afternoon notation, which fails to convert to datetime in SQL Server and SQL statements. In the development of our one if encountered this problem will basically solve, afraid to forget this point, the program released, the customer said an update on the error, and you always said no problem, hehe

Today in the customer to help clients adjust a program to meet this problem, do a good job to find out the original problem here, spend a lot of time, the post for everyone to learn from.