3727812 - DATEDIFF Behavior Changed when built-in function using the hh datepart - SAP ASE

• After upgrading SAP Adaptive Server Enterprise  to SAP ASE 16.0 SP04 PL08, customers observe different results when executing the DATEDIFF() built-in function using the hh datepart.

          Example:

      SELECT DATEDIFF(hh,'09:07','09:37')

         Returned result:

         1

         Expected result based on historical ASE behavior:

             0

• The results differ from the historical ASE implementation where DATEDIFF() counted the number of datepart boundaries crossed.
• This behavior change may impact existing applications that rely on the previous semantics.

SAP  ASE 16.0 SP04 PL08

datediff, CR 829885, CR 831874, boundary crossing, rounding behavior,  datetime calculation  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem