SAP Knowledge Base Article - Preview

3727812 - DATEDIFF behavior for hh datepart option changed and returns unexpected result - SAP ASE

Symptom

  • After upgrading to SAP ASE
    • 16.0 SP04 PL08 or
    • 16.1 SP00 PL01 / PL02

  • When executing the DATEDIFF built-in function using the hh datepart option.
  • A different result is returned compared to previous ASE releases

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

    Result in above releases :  1

    Result in all previous ASE releases:  0
  • This behavior change may impact existing applications that rely on the previous expected result.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
    • 16.0 SP04 PL08
    • 16.1 SP00 PL01 / PL02

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.