how to convert mm/dd/yyyy to yyyy-mm-dd in sql server?
You may use PARSE() to create DATETIME object from culture-specific format and then convert it to required string: select convert(varchar(20), parse('02/15/2016' as datetime2 using 'en-US'), 20); 20 is CONVERT()'s specific code for ODBC's date style (YYYY-mm-dd).