Get Started with Redwood: Oracle Cloud SCM and Purchasing
How do I Round Down my TIMESTAMPDIFF formula
Summary:
I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
TIMESTAMPDIFF(SQL_TSI_YEAR, "Workforce Management - Worker Assignment Real Time"."Worker Assignment Details"."PER_ASG_DF_CNTNS_SRVC_T_", CURRENT_DATE)
Tagged:
0