[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Date format
>> 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|