Add Days to day_start_time — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Add Days to day_start_time

in Reporting and Analytics for HCM 2 comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!