• Good Question, but not valid for all languages, since some have different date formats (ymd):

    Japanese

    Swedish

    Hungarian

    Croatian

    Latvian

    Lithuanian

    Traditional Chinese

    Korean

    Simplified Chinese

    SELECT dateformat, name, alias FROM sys.syslanguages WHERE dateformat NOT LIKE '%y'

    Best Regards,

    Chris Büttner