X

PaaS Partner Community

Change date time format in Oracle Integration Cloud by Ankur Jain

Juergen Kress
PaaS & Middleware Partner Adoption
image

We got a request from multiple folks saying they are struggling to change the date time format in Oracle Integration Cloud.

We are writing this article to see how to change the default date format(2019-04-13T05:09:05.049+00:00) to a different format.

Oracle Integration Cloud Service provides an Out of the box function(xp20:format-dateTime) which allows us to change the date time format. We are on ICS version (18.4.3.0.3) and the function is available(xp20:format-dateTime). Let us see how to apply this function and change the date format as per the requirement. The function(xp20:format-dateTime) takes below two arguments:

  1. dateTime: Provide the DateTime input parameter as a string which needs to be the format
  2. Format: Provide the format as a string as per the requirement

Example-1: Parse the date time in the format "dd-MM-yyyy", below will be the syntax: Read the complete article here.

PaaS Partner Community

For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.

clip_image003 Blog clip_image005 Twitter clip_image004 LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Technorati Tags: SOA Community,Oracle SOA,Oracle BPM,OPN,Jürgen Kress

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.