• The database i tested my answer on has "us_english" as the default language.
    the script would therefore interpret the date provided as  MM/dd/yyyy

    Interestingly, if the SET LANGUAGE British was placed at the top of the script, the  date would be interpreted as dd/MM/yyyy...

    Language settings are important....

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”