2543174 - Error 247 when converting character string to a DATE or DATETIME datatype - SAP ASE

Error 247 when  converting a string to a date where the first field value is larger then 12

Example:
Msg 247, Level 16, State 1:

Arithmetic overflow during explicit conversion of VARCHAR value '28/09/2017' to a DATETIME field

SAP Adaptive Server Enterprise (ASE)

Data string error, message 247, msg 247, month order in data string, American date format, US date format error, date, datetime, bigdatetime, cast, convert , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem