SSDN - Add characters in Date and Time

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Alicia Roberts

Subject: Add characters in Date and Time
Author: Alicia Roberts
Date: 21 Apr 2005 10:21 AM

I'm concatenating two fields (Date and Time) and the output looks like
<eb:Timestamp>20050421100342</eb:Timestamp>. However, I have to add dashes(-) in the date, the letter "T", colons(:), and ".000" in the time. I need the output to look like,
<eb:Timestamp>2005-04-21T10:03:42.000</eb:Timestamp>.

Can you help me achieve this output?

(Deleted User)

Subject: Add characters in Date and Time
Author: (Deleted User)
Date: 21 Apr 2005 10:37 AM

you need to use concat function and substring function to do it.

something like:

concat(substring(datestr, 1, 4), '-', substring(datestr, 5,2), '-'...).

Alicia Roberts

Subject: Add characters in Date and Time
Author: Alicia Roberts
Date: 21 Apr 2005 11:11 AM

Thanks so much. I was able to get the output, I needed.

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.