Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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