Question
PEGA
Pegasystems Inc.
JP
PEGA
Posted: Jun 27, 2016
Last activity: Jun 27, 2016
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.
Posted: 8 years ago
Pegasystems
IN
This 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.