3245475 - Msg 247 Arithmetic overflow during implicit conversion of VARCHAR value 'DD/MM/YYYY' to a DATE field for SAP ASE

• When passed "dd/mm/yyyy" the below sql fails with below message. For example:
  
  select max(hdrVersion) as mxVersion, max(hdrFileFormatVersion) as mxFileFormatVersion from tblSolvencyTrans_VersionInfo
  where CONVERT(DATE,ValuationDate,103) = 'dd/mm/yyyy'
  
  Msg 247, Level 16, State 1:
  Server 'XYZ', Line 1:
  Arithmetic overflow during implicit conversion of VARCHAR value 'dd/mm/yyy' to a DATE field .

SAP Adaptive Server Enterprise (ASE) 16.0

Error 247 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem