Date Format In Oracle Integration Cloud
Oracle Integration Cloud (OIC) allows you to work with dates in different formats. You can use the built-in Date and Time functions, XSLT functions, and JavaScript to handle date formats.
When working with dates in Oracle Integration Cloud, you can use the following date formats:
ISO 8601 Format: This format is widely used and follows the pattern “YYYY-MM-DDTHH:MI:SSZ”. For example, “2023-08-05T12:30:00Z”.
Oracle Date Format: Oracle Integration Cloud supports Oracle’s standard date format masks, such as “DD-MON-YY” or “DD-MM-YYYY”.
Custom Date Format: You can create your custom date format using XSLT functions or JavaScript functions depending on the requirements.
It is essential to be cautious when parsing and converting dates to ensure the correct format is used. If you are dealing with date transformations or handling date data in Oracle Integration Cloud.