SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SET LANGUAGE French;
DECLARE @date datetime ='2019-01-31 00:00:00.007'
SELECT @date;
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.

SET LANGUAGE BRITISH;
DECLARE @date datetime ='2019-01-31 00:00:00.007'
SELECT @date;
Msg 242 Level 16 State 3 Line 2
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

SET LANGUAGE ENGLISH; --American
DECLARE @date datetime ='2019-01-31 00:00:00.007'
SELECT @date;

(No column name)

31/01/2019 00:00:00

Changed language setting to us_english.

SET LANGUAGE FRENCH;
DECLARE @date datetime ='2019-01-31T00:00:00.007'
SELECT @date;

(No column name)

31/01/2019 00:00:00

Le paramètre de langue est passé à Français.

SET LANGUAGE BRITISH;
DECLARE @date datetime ='2019-01-31T00:00:00.007'
SELECT @date;

(No column name)

31/01/2019 00:00:00

Changed language setting to British.

SET LANGUAGE ENGLISH; --American
DECLARE @date datetime ='2019-01-31T00:00:00.007'
SELECT @date;

(No column name)

31/01/2019 00:00:00

Changed language setting to us_english.