Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here

Adding Number of Minutes to Date using GET_HH_MM_DATETIME

Oct 18, 2023 5:29PM in Workforce Management 2 comments

Summary:

We wanted to build a formula which will add minutes to the date. For Ex: Current Date: 18-Oct-2023 6:00 AM,

After adding 10 minutes through function the outcome will be like 18-Oct-2023: 10:00 AM

Content (please ensure you mask any confidential information):

am using the above mentioned function in one of the OTL formula, and receiving the below error.

Please guide me what will be the format which is accepted by system.

used in formula:StartEnd = GET_HH_MM_DATETIME(schStartTime,TO_CHAR('00:10:00',HH24:MI:SS) )

Value Returns: 2023-10-18 00:10:00

Expected Returns: 2023-10-18 06:10:00

Version (include the version you are using, if applicable):

Tagged:

To view full details, sign in.

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