When working with dates and times in SQL Server, it's common for formatting discrepancies to cause issues during query execution. To prevent errors, it's. Menu; Search for; ... = '10/1/15 21:02:04' ...