Is there a date format in ms sql that does not depend on regional settings?

Question

SQL Server

Is there a date record format in ms sql that unambiguously translates into the correct date, regardless of the regional and language settings of the server?

Answer 1

ISO 8601 Description
YYYY-MM-DDThh:mm:ss[.mmm]
YYYYMMDD[ hh:mm:ss[.mmm]] Examples:
1. 2004-05-23T14:25:10
2. 2004-05-23T14:25 :10.487
The advantage of the ISO 8601 format is that it is an international standard with an unambiguous representation. Also, this format is not affected by the SET DATEFORMAT and SET LANGUAGE settings.
No one hides, is on msdn at the request of datetime.