Symptom
- 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 thehhdatepart.
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.
Read more...
Environment
SAP ASE 16.0 SP04 PL08
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.
SAP Knowledge Base Article - Preview