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 (22.214.171.124.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:
Example-1: Parse the date time in the format "dd-MM-yyyy", below will be the syntax: Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.