SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT CONVERT(datetime, '2021-09-07'); -- September 7th
SET LANGUAGE Nederlands;
SELECT CONVERT(datetime, '2021-09-07'); -- July 9th

(No column name)

2021-09-07 00:00:00.000

(No column name)

2021-07-09 00:00:00.000

De taalinstelling is gewijzigd in Nederlands.

SET LANGUAGE us_english;
SELECT CONVERT(datetime, '2021-09-13'); -- September 13th

(No column name)

2021-09-13 00:00:00.000

Changed language setting to us_english.

SET LANGUAGE French;
SELECT CONVERT(datetime, '2021-09-13'); -- error
Msg 242 Level 16 State 3 Line 2
La conversion d'un type de données varchar en type de données datetime a créé une valeur hors limites.