Question1Replies316Views×Close popoverChunzhi Hong (Chunzhi_Hong) PEGA Consulting Manager, Pega Consulting Pegasystems Inc. JP View ProfileSend Message Chunzhi_Hong Member since 2013 138 posts PEGA Posted: June 27, 2016Last activity: June 27, 2016Posted: 27 Jun 2016 1:35 EDTLast 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. 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 agoPosted: 27 Jun 2016 7:51 EDT×Close popoverRajiv Nistala (nistr) PEGA Senior Manager - Engineering Pegasystems IN View ProfileSend Messagenistr 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.