Example of using SET DATEFORMAT in SQL

SQL Server SET DATEFORMAT is used to set the order of the month, day, and year date parts for interpreting date character strings.