Blog Posts Process Management Service Oriented Architecture (SOA)

Change date time format in Oracle Integration Cloud by Ankur Jain

Blog: PaaS Community

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:

dateTime: Provide the DateTime input parameter as a string which needs to be the format
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.

Blog Twitter LinkedIn Facebook Wiki