Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Absences Report
Summary
get the working dates between start_date and end_dateContent
we have requiremnet to generate absences report, need help on sql query,
If any empployee having absence start date as 01-oct-2018 and end date is 08-oct-2018
output should be like below. as 06-oct-2018, 07-oct-2018 weekends( saturday and sunday) should not include in output
start date end date hours
01-oct-2018 01-oct-2018 8
02-oct-2018 02-oct-2018 8
03-oct-2018 03-oct-2018 8
04-oct-2018 04-oct-2018 8
05-oct-2018 05-oct-2018 8
08-oct-2018 08-oct-2018 8
0