Using DATEFORMAT in SQL with example

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