jcelko212 32090 - Monday, March 5, 2018 6:34 PM
Apparently, you've never actually read the standards, which allow for two formats. YYYYMMDD as the primary/preferred format and YYYY-MM-DD as a secondary format, which silently screws you in SQL Server depending on the default language. For example, if the French language is the default, SQL Server will actually use or consume what you think is YYYY-MM-DD as YYYY-DD-MM and will only report an error if you violate the allowed range for any of the parts.
--Jeff Moden
Change is inevitable... Change for the better is not.