Here we will see how to use template to get following date format.
Input:
<HIRE_DATE>30-JAN-2012</HIRE_DATE>
Output:
<HIRE_DATE>2012-01-30</HIRE_DATE>
In the XSLT :
In the main template use:
<ns1:hireDate>
<xsl:call-template name="formatDate">
<xsl:with-param name="date" select="HIRE_DATE"/>
</xsl:call-template>
</ns1:hireDate>
Called template:
<xsl:template name="formatDate">
<xsl:param name="date"/>
<xsl:variable name="year" select="substring($date, 8, 4)"/>
<xsl:variable name="month" select="substring($date, 4, 3)"/>
<xsl:variable name="day" select="substring($date, 1, 2)"/>
<xsl:choose>
<xsl:when test="$month='JAN'">
<xsl:value-of select="concat($year,'-01-',$day)"/>
</xsl:when>
<xsl:when test="$month='FEB'">
<xsl:value-of select="concat($year,'-02-',$day)"/>
</xsl:when>
<xsl:when test="$month='MAR'">
<xsl:value-of select="concat($year,'-03-',$day)"/>
</xsl:when>
<xsl:when test="$month='APR'">
<xsl:value-of select="concat($year,'-04-',$day)"/>
</xsl:when>
<xsl:when test="$month='MAY'">
<xsl:value-of select="concat($year,'-05-',$day)"/>
</xsl:when>
<xsl:when test="$month='JUN'">
<xsl:value-of select="concat($year,'-06-',$day)"/>
</xsl:when>
<xsl:when test="$month='JUL'">
<xsl:value-of select="concat($year,'-07-',$day)"/>
</xsl:when>
<xsl:when test="$month='AUG'">
<xsl:value-of select="concat($year,'-08-',$day)"/>
</xsl:when>
<xsl:when test="$month='SEP'">
<xsl:value-of select="concat($year,'-09-',$day)"/>
</xsl:when>
<xsl:when test="$month='OCT'">
<xsl:value-of select="concat($year,'-10-',$day)"/>
</xsl:when>
<xsl:when test="$month='NOV'">
<xsl:value-of select="concat($year,'-11-',$day)"/>
</xsl:when>
<xsl:when test="$month='DEC'">
<xsl:value-of select="concat($year,'-12-',$day)"/>
</xsl:when>
</xsl:choose>
</xsl:template>
