Extracting Time from Date/Time

Navy1991_1 · June 3rd, 2008, 09:55 AM

Is there a simple way to extract just "Time" from "Date/Time"?

Sample:
<effectiveTime value="200710221030" />

Martin Honnen · June 3rd, 2008, 10:10 AM

XSLT/XPath 2.0 supports dateTimes in the format yyyy-mm-ddThh:mm:ss but not in the format you show.
So you first need to convert your format.

--
Martin Honnen
Microsoft MVP - XML

mhkay · June 3rd, 2008, 12:03 PM

Alternatively, if you're going to use your own format:

(a) substring(@value,9)

(b) @value mod 10000

both have the required effect.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference