clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2555490 fiddles created (37455 in the last week).

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.
 hidden batch(es)


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.
 hidden batch(es)


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.
 hidden batch(es)