Change date time format in Oracle Integration Cloud by Ankur Jain
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 (220.127.116.11.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.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.