Hi, I am using toxml() to convert CDT to XML. This conversion appends

Hi,

I am using toxml() to convert CDT to XML. This conversion appends a 'Z' to the end of date,date time, and time data types. For example:"020-04-01Z" . How to get rid of this "Z"?

Any help is appreciated!
Thanks!

OriginalPostID-155502

OriginalPostID-155502

  Discussion posts and replies are publicly visible

  • The Z indicates that the date or time is in UTC, and its inclusion is part of the XML Schema spec. If you want temporal types (date, datetime, and time) rendered in some other format in your XML output, you can specify a text type in your XSD, and use the text() function to convert dates to your desired format.

    Or perhaps you can apply a regular expression to the output of toxml() to remove any instances of 'Z' that are followed immediately by '</'? I don't think that approach is ideal for performance and repeatability reasons.