Question: how to convert mm/dd/yyyy to yyyy-mm-dd in sql?
Answer: SELECT CONVERT(CHAR(19), CONVERT(DATETIME, '11/10/11 10:56:58', 3), 120); Finally, use the correct number of characters in your char or varchar declarations. Not specifying a length is lazy and can lead to problems.