• These conversions are non deterministic, but from string to date:

    from BOL:

    Certain datetime Conversions Are Nondeterministic in SQL Server 2005 and Later Versions

    In SQL Server 2000, string to date and time conversions are marked as deterministic. However, this is not true for the styles listed in the following table. For these styles, the conversions depend on the language settings. SQL Server 2005 and later versions mark these conversions as nondeterministic.

    The following table lists the styles for which the string-to-datetime conversion is nondeterministic.

    All styles below 100 (1)

    106 107 109 113 130

    (1) With the exception of styles 20 and 21