O'Reilly logo
  • Dustin Waybright thinks this is interesting:

The question is, when SQL Server converts this character string to a date and time type to align it with the filtered column’s type, how does it interpret the value? As it turns out, it depends on the language of the logon that runs the code.


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


European versus American versus Japanese dates for example.