Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
7 subscribers
Views
1846 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi, I am using toxml() to convert CDT to XML. This conversion appends
jayashrib223
over 8 years ago
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
Parents
0
Colin Teubner
Appian Employee
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Colin Teubner
Appian Employee
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data