This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Date format
- From: "Ali Mutlu" <alimutlu at 32bit dot com dot tr>
- To: <xsl-list at lists dot mulberrytech dot com>
- Date: Thu, 30 May 2002 16:15:36 +0300
- Subject: RE: [xsl] Date format
- Reply-to: xsl-list at lists dot mulberrytech dot com
>> I have a date 17-MAY-02 from the oracle database that I would like to
>> format as YYYYMMDDHR24MI and another date 117-MAY-02 to be converted to
>> YYYYMMDD.
>> I wish to do the transformation in the XSLT. Has anyone done this before
>> and if so how did you do it?
Akila,
The following template translates anything like dd-mmm-yyyy to yyyymmdd, I
beleive a shorter way may exists, but it works
Rgds
Ali
<xsl:template name="ConvertRtDate">
<xsl:param name="ADate"/>
<xsl:value-of select="substring($ADate,8,4)"/>
<xsl:choose>
<xsl:when test="substring($ADate,4,3)='JAN'">
<xsl:value-of select="'01'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='FEB'">
<xsl:value-of select="'02'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='MAR'">
<xsl:value-of select="'03'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='APR'">
<xsl:value-of select="'04'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='MAY'">
<xsl:value-of select="'05'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='JUN'">
<xsl:value-of select="'06'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='JUL'">
<xsl:value-of select="'07'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='AUG'">
<xsl:value-of select="'08'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='SEP'">
<xsl:value-of select="'09'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='OCT'">
<xsl:value-of select="'10'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='NOV'">
<xsl:value-of select="'11'"/>
</xsl:when>
<xsl:when test="substring($ADate,4,3)='DEC'">
<xsl:value-of select="'12'"/>
</xsl:when>
</xsl:choose>
<xsl:value-of select="substring($ADate,1,2)"/>
</xsl:template>
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list