Subject: RE: [xsl] Date format From: AXRAMAKR@xxxxxx Date: Thu, 30 May 2002 10:08:45 -0500 |
Ali, Thanks for your help. However, when I call the template like this <xsl:call-template name="ConvertRtDate"> <xsl:with-param name="ADate" select ="@trndte"/> </xsl:call-template> The date of 17-MAY-02 gets converted to 020517. How do I make it 20020517? Thanks, Akila "Ali Mutlu" <alimutlu@xxxxxxxxxxxx> To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> Sent by: cc: owner-xsl-list@xxxxxxxxxxx Subject: RE: [xsl] Date format rrytech.com 05/30/02 08:15 AM Please respond to xsl-list >> 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 XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Date format, gary cor | Thread | RE: [xsl] Date format, Ali Mutlu |
Re: AW: [xsl] xsl:include href-attr, Joerg Heinicke | Date | [xsl] XInclude, Sal Mangano |
Month |