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.