Question

1
Replies
320
Views
Chunzhi Hong (Chunzhi_Hong)
PEGA
Consulting Manager
Pegasystems Inc.
JP
Chunzhi_Hong Member since 2013 141 posts
PEGA
Posted: June 27, 2016
Last activity: June 27, 2016
Posted: 27 Jun 2016 1:35 EDT
Last activity: 27 Jun 2016 7:51 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.