Search code examples
datetimexslttransformxslt-2.0

Convert datetime in xslt


How should i convert datetime in xslt if i get the datetime in GMT in below format

<date>2017-02-05T10:40:00+04:00</date>

output : 2017-02-05 14:40:00.000

Solution

  • In XSLT 2.0, you can do:

    <xsl:template match="date">
        <xsl:copy>
            <xsl:value-of select="adjust-dateTime-to-timezone(., xs:dayTimeDuration('PT0H'))"/>
        </xsl:copy>
    </xsl:template>
    

    to convert:

    <date>2017-02-05T10:40:00+04:00</date>
    

    into:

    <date>2017-02-05T06:40:00Z</date>