RE: Formatting a date

Subject: RE: Formatting a date
From: "Mark Giacobbe" <mgiacobbe@xxxxxxxxxxxxxx>
Date: Mon, 14 Aug 2000 14:24:13 -0400
pretty is in the eye of the beholder, but have you tried using concat()?

<xsl:value-of
select="concat(substring(.,5,2),'/',substring(.,7,2),'/',substring(.,1,4),'
',
substring(.,10,2),':',substring(.,12,2),':',substring(.,14),' GMT')"/>

mark giacobbe
mgiacobbe@xxxxxxxxxxxxxx


>hi all,
 A little efficiency question for you.
 I have a date which is in the form of "CCYYMMDD.HHMMSS" and I'm
formatting this date to look like this: "MM/DD/YYYY HH:MM:SS GMT".  I have
my own way of doing this but I suspect that there is a better way.  Can
anyone tell me if there is?  I tried format-number() originally but it
choked on the ":".  What I'm doing now works but isn't very pretty.  Code
below.
 - Heather


XML:
<Date>19981003.133045</Date>

XSL:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<xsl:template match="/Date">
 <html>
  <head></head>
  <body>
   <p>
    <xsl:value-of
select="substring(.,5,2)"/><xsl:text>/</xsl:text><xsl:value-of
select="substring(.,7,2)"/><xsl:text>/</xsl:text><xsl:value-of
select="substring(.,1,4)"/><xsl:text> </xsl:text><xsl:value-of
select="substring(.,10,2)"/><xsl:text>:</xsl:text><xsl:value-of
select="substring(.,12,2)"/><xsl:text>:</xsl:text><xsl:value-of
select="substring(.,14)"/><xsl:text> GMT</xsl:text>
   </p>
  </body>
 </html>
</xsl:template>
</xsl:stylesheet>

OUTPUT:
<html>
 <head></head>
 <body>
 <p>10/03/1998 01:30:45 GMT</p>
 </body>
</html>


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread