How to read an xsd:dateTime with msxml?

Question

I'm using the msxml to parse an xml file. Language is C++. The xml file contains some dates and times using the xsd:dateTime format (Something like that: 2009-04-29T12:00:00Z)

Is there an easy way to convert xsd:dateTime to something like SYSTEMTIME, FILETIME or VariantTime?

Answer 1

Maybe this helps you: Using strptime to parse ISO 8601 formated timestamps on ioncannon.net.

Answer 2

You can use a javascript:

<xsl:transform
id="integra-transformer"
version="1.0"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:date="urn:date-scripts">

<xsl:output method="xml" indent="yes" />

<msxsl:script 
 implements-prefix="date" 
 language="javascript">
 <![CDATA[
 Date.prototype.toISO8601ShortString = function () {
  var zeropad = function (num) { return ((num < 10) ? '0' : '') + num;  }
  var str = "";
  var date = new Date();
  str += date.getUTCFullYear();
  str += "-" + zeropad(date.getUTCMonth() + 1);
  str += "-" + zeropad(date.getUTCDate());
  str += "T" + zeropad(date.getUTCHours()) +
  ":" + zeropad(date.getUTCMinutes());
  return str;
 }

 function getToday()
 {
  var d;
  d = new Date();
  return(d.toISO8601ShortString());
 }
 ]]>
</msxsl:script>


<xsl:template match="/">
         <date>
             <xsl:value-of select="date:getToday()"/>
         </date>
     </xsl:template>
 </xsl:transform>

Don't forget to enable scripts befor you do the transformation:

xslDom.setProperty("AllowXsltScript", true)