Change Date Time Format In Oracle Integration Cloud


Change Date Time Format In   Oracle Integration Cloud

In Oracle Integration Cloud (OIC), you can change the date and time format by configuring transformations and mappings within your integration flows. Here are the general steps to change the date and time format in OIC:


  1. Open Your Integration Flow:
    1. Log in to your Oracle Integration Cloud account.
    2. Navigate to the Integration section and open the specific integration flow where you need to change the date and time format.
  2. Configure Data Mapping:
    1. In your integration flow, you may need to map data from one format to another. This is where you can adjust the date and time format.
  3. Use Functions or Expressions:
    1. Inside the data mapping, you can use functions or expressions to manipulate the date and time values.
    2. For example, you can use the to_char function to format a date or timestamp field into your desired format. Here’s an example of how to do this in a mapping:
    3. to_char(timestamp_field, ‘YYYY-MM-DD HH24:MI:SS’)
    4. In this example, timestamp_field is the field you want to format, and ‘YYYY-MM-DD HH24:MI:SS’ is the desired date and time format.
  4. Test and Deploy:
    1. After making changes to the data mapping and date/time formatting, it’s essential to test your integration to ensure the desired format is applied correctly.
    2. Once you are satisfied with the results, save and deploy your integration.
  5. Monitoring:
    1. Monitor your integration for any issues related to date and time format conversions, especially when integrating with other systems.

Oracle Integration Cloud (OIC) Training Demo Day 1

You can find more information about Oracle Integration Cloud Service in this Oracle Docs Link



Unogeeks is the No.1 Training Institute for OIC. Anyone Disagree? Please drop in a comment

Please check our Oracle Integration Cloud Training Details here OIC Training

You can check out our other latest blogs on Oracle Integration Cloud in this OIC Blogs

💬 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at:

Our Website ➜

Follow us:





Leave a Reply

Your email address will not be published. Required fields are marked *