Search notes:

SQL Server: unambiguous date literals

Apparently, there are only two date formats that are independent on the language chosen or other settings:
declare @dt as datetime;

set @dt = '2018-08-28T20:21:22';
print (@dt);

set @dt = '20111213 18:19:20';
print (@dt);
Github repository about-MSSQL, path: /t-sql/data-types/dates/unambiguous-formats.sql

Index