How to Fix ‘Conversion failed when converting date and time’ in SQL Server. By Kevin Arrows Updated on ... (e.g., January 10, 2015, or 10/1/2015), which we can achieve using SQL Server’s built-in ...

SQL Server has many different ways (column types) to represent date/time values, and depending on which one is used in the database table, you may have some surprising results when trying to consume ...