Subject: RE: [xsl] Date format From: "Ali Mutlu" <alimutlu@xxxxxxxxxxxx> Date: Thu, 30 May 2002 16:15:36 +0300 |
>> 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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Date format, AXRAMAKR | Thread | RE: [xsl] Date format, Stevenson Ngila |
[xsl] xsl:include href-attribute, Pfitzner, Jan | Date | Re: [xsl] separator defninition, David Carlisle |
Month |