Convert XML String to Datetime/Timestamp

cognito · September 26th, 2013, 02:56 PM

Hi. I have a project where I pull data from an xml file using xslt. I was successful in doing so, however, one of the xml field is a date in this format.
2013-09-17 11:48:26
the xml file looks like this:
<Fields>
<Field Name="datePurchased" Value ="2013-09-17 11:48:26"/>
<Field Name="customerName" Value = "James" />
<Field Name="customerItem" Value = "Bottled water" />
</Fields>

I want the output to be this

<![CDATA[2013/09/17 11:48:26.0 EDT]]

By the way: I am super new to xslt.

samjudson · September 26th, 2013, 05:27 PM

The following does what you ask - whether that is what you actually wanted or not is another matter.

Code:

<xsl:value-of select="concat(translate(/Fields/Field[@Name='datePurchased']/@Value, '-', '/'),'.0 EDT')"/>

Basically it just treats the attribute as a string (which it is).