Question

1
Replies
314
Views
Chunzhi_Hong Member since 2013 138 posts
PEGA
Posted: June 27, 2016
Last activity: June 27, 2016
Closed
Solved

7.2 why does pxDifferenceInDays (for Oracle) return "ROUND HALF UP" value instead of "ROUND DOWN" value as the  base rule does?

I found that SQL function pxDifferenceInDays, that is circumstanced for Oracle, returns "ROUND HALF UP" value instead of "ROUND DOWN" value.

What is the rationale behind this implementation?


In my opinion, SQL functions are circumstanced to address different syntax and database functions used in different RDBMS product,

however, they must return same value as the base rule does.

pxdifferenceindays.JPG

Case Management Data Integration Reporting
Moderation Team has archived post
Share this page LinkedIn