Need Date Format in XSLT

garinapavan · November 12th, 2009, 02:14 PM

Hi ,

I get the date in the below format in one element :
2009-06-17T00:00:00

and need to convert and format the same in to 06172009.

I need to do that in XSLT . can some body please suggest me some thing.

Any help is appreciated.

Pavan

Martin Honnen · November 12th, 2009, 02:26 PM

Well with XSLT/XPath 2.0 you could create an xs:dateTime(foo) and then use methods like format-dateTime http://www.w3.org/TR/xslt20/#function-format-dateTime.

Code:

  <xsl:template match="foo">
    <xsl:value-of select="format-dateTime(xs:dateTime(.), '[M01][D01][Y0001]')"/>
  </xsl:template>

With XSLT/XPath 1.0 you will need to use string functions e.g.
concat(substring(foo, 6, 2), substring(foo, 9, 2), substring(foo, 1, 4))

garinapavan · November 12th, 2009, 03:49 PM

Thanks Martin