"dateformat" independent form of datetime string in query for SQL Server?
Use datetime strings in ISO 8601 format:
YYYY-MM-DDThh:mm:ss[.mmm]
YYYYMMDD[ hh:mm:ss[.mmm]]


To use the ISO 8601 format, you must specify each element in the
format, including the T, the colons (:), and the period (.) that are
shown in the format.
The brackets indicate that the fraction of second component is
optional. The time component is specified in the 24-hour format.
The T indicates the start of the time part of the datetime value.
The advantage in using the ISO 8601 format is that it is an
international standard with unambiguous specification. Also, this
format isn't affected by the SET DATEFORMAT or SET LANGUAGE setting.

More info