SET DATEFORMAT (Transact-SQL) Sets the order of the month, day,
and year date parts for interpreting date, smalldatetime,
datetime, datetime2 and datetimeoffset character strings. For an
overview of all Transact-SQL date and time data types and
functions, see Date and Time Functions (Transact-SQL). For
information and examples that are common to date and time data
types and functions, see Using Date and Time Data. The
DATEFORMAT ydm is not supported for date, datetime2 and
datetimeoffset data types. The effect of the DATEFORMAT setting
on the interpretation of character strings might be different
for datetime and smalldatetime values than for date, datetime2
and datetimeoffset values, depending on the string format. This
setting affects the interpretation of character strings as they
are converted to date values for storage in the database. It
does not affect the display of date data type values that are
stored in the database or the storage format. Some character
strings formats, for example ISO 8601, are in