IBM Integration Community Come for answers. Stay for best practices. All we’re missing is you. Join / Log in Ask a question
I am using IBM ACE v12.7. I am converting DATE into CHAR. I am supposed to get date in 08-Sep-2022 format while giving input as 08-09-2022.
But I am getting 08-Sept-2022 when I am deploying the service in other system. Kindly help to resolve this issue. I have attached zip file of the same.
This looks like the same issue (to do with a change in behaviour in newer versions of the ICU library which ACE uses) : https://www.ibm.com/support/pages/apar/IT41966
This snippet using REPLACE function may also be helpful as a quick means of fixing:
SET Environment.Date = CAST(InputRoot.JSON.Data.Date as DATE FORMAT 'dd-MM-yyyy'); SET OutputRoot.JSON.Data.DATE=REPLACE(CAST(Environment.Date AS CHAR FORMAT 'dd-MMM-yyyy'),'Sept','Sep');