sql server set dateformat

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