In the Oracle database, you can count the number of days between two dates by subtracting the dates from each other. And Oracle returns the number of days in between those dates. However, sometimes, and especially in HCM, we are interested in the number of working days. For instance, if we want to calculate the absence percentage of an employee.
We share our passion for technology and innovation
Read the blog posts by Qualogy's tech experts, with tips, practical experiences and lightbulb moments. Select a category or search by tag to find relevant information, codes and step-by-step plans. Submit your comment or question.
Counting working days in the Oracle database without a calendar Published on: Author: Stefan van Glabbeek Category: OracleRead more