CODEWITHSUNDEEP
xmlxsltxsd
Aiden
Aiden

Reputation: 460

Convert date yyyyMMdd to yyyy-MM-dd'T'HH:mm:ss format with XSLT

I have date in XML as

<TODAYDATE>20160509<TODAYDATE>

I want to convert it using xsl

<com2:TodayDat>
    <xsl:value-of select="TODAYDATE" />
</com2:TodayDat>

but I want it in format yyyy-MM-dd'T'HH:mm:ss using some function etc in xsl. It should show as 2016-05-09T00:00:00

Please help

Thanks,

Aiden

Upvotes: 0

Views: 2910

Answers (1)

Ali Soltani
Ali Soltani

Reputation: 9937

You can use this code

     <xsl:value-of select="substring(TODAYDATE, 1, 4)" />-<xsl:value-of select="substring(TODAYDATE, 5, 2)" />-<xsl:value-of select="substring(TODAYDATE, 7, 2)" /> T00:00:00

Online output:http://xsltransform.net/94AbWAN/2

Upvotes: 1

Related Questions