My Oracle Support Banner

Groovy Scripting : Need To Convert Datetime Field In UTC Standard To User's Local TimeZone (Doc ID 2933821.1)

Last updated on MARCH 30, 2023

Applies to:

Oracle Fusion CX Sales Cloud Service - Version 11.13.22.10.0 and later
Information in this document applies to any platform.

Goal

When an OTB date/time field value is entered from UI, application automatically convert the date/time to UTC.  It is needed to convert this date/time back to user timezone and store it to a custom date type field.

e.g

User enter

ActivityEndDate = 2023-Mar-07 9:00:00 pm EST (UTC -5)

Application will save 2023-Mar-08 2:00:00 am to the DB

If a custom date field is taking the value from ActivityEndDate, it will show 2023-Mar-08 instead 2023-Mar-07

The need is to show 2023-Mar-07
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.