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.

Attachment(s)

DateDemo.zip   2 KB 1 version

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');