Solving the Datetime Mystery | SQL Server content from SQL Server Pro

we'll both get a date that specifies October 12, 2000. Make sure that you always put dates in single quotes. SQL Server applies your DATEFORMAT setting only when it converts character strings to datetime values. If you omit the quotes in the example above

sqlmag.com