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.
Add Days to day_start_time
Team,
How to add days to datetimestamp.
We have a requirement to add one week to the date timestamp and display.
day_start_time in hwm_tm_rpt_entry_v. If the date is 25-Aug-2023 and we are trying to add 7 days day_start_time +7 (Which is 01-Sep-2023).
But we are getting error. "ORA-01791: not a SELECTed expression"
Please share if you have any idea.
0