Question1Replies314Views Chunzhi_Hong Member since 2013 138 posts PEGA Posted: June 27, 2016Last 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. Case Management Data Integration Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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. Posted: 4 years agonistr PEGA replied to Chunzhi_HongThis function has been in existence for a long time. We don't think we can change the behaviour now since it would cause regression issues for existing customers using this function.