Subject: RE: [xsl] Date format From: "Ali Mutlu" <alimutlu@xxxxxxxxxxxx> Date: Thu, 30 May 2002 18:44:46 +0300 |
Akila, replace the line <xsl:value-of select="substring($ADate,8,4)"/> with <xsl:text>20</xsl:text> <xsl:value-of select="substring($ADate,8,2)"/> Rgds Ali -----Original Message----- From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of AXRAMAKR@xxxxxx Sent: Thursday, May 30, 2002 18:09 To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Cc: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx; xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: RE: [xsl] Date format 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 XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Date format, AXRAMAKR | Thread | RE: [xsl] Date format, AXRAMAKR |
Re: [xsl] XInclude, Joerg Heinicke | Date | Re: [xsl] xpointers with xsl, Joerg Heinicke |
Month |