Re: Converting date formats

Hi, Doug:

  If you are new to XSLT, you really should start by
going through a primer before trying to code anything
productive.  If you have any question, check out FAQ
at http://www.laidback.org/dpawson/xsl/xslfaq.html
first.
  In any case, here is a complete working XSL
illustrate date formatting.  I set current date into a
variable and output it in the format you wanted.  This
is a good start point for you to massage this code
into your own code:
<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
  <xsl:template match="/">	
    <xsl:variable name="date" select="20010607"/>
    <xsl:value-of select="concat(substring($date, 7,
2),'/',substring($date, 5, 2),'/',substring($date, 1,
4))"/>
  </xsl:template>
</xsl:stylesheet>

Hope this helps,
Xiaocun

--- "Hewko, Doug" <Doug.Hewko@xxxxxxxxxxxxxxx> wrote:

Thanks for the help. Do you have an example? I am
very new to XML (just
starting to learn even what a DTD is for) and am
unable to get the previous
suggestions to work. When I entered the
"xsl:variable" solution, I got a
"can not use xsl:variable there" type message.

-----Original Message-----
From: Gary Frederick
[mailto:gary.frederick@xxxxxxxxx]
Sent: June 7, 2001 2:41 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: Re:  Converting date formats

Others gave the direct way to translate dates. You
can also use the XSLT Standard Library
http://xsltsl.sourceforge.net/

=====
I use it to print events for a calendar. The input
is iCalendar converted to XML.

...
<DTSTART>
   <param kind="TZID">CT(America/Chicago)</param>
   <value>20010609T090000</value>
</DTSTART>

The stylesheet parts are
...
<xsl:call-template name="DATE">
   <xsl:with-param name="this-date"
select="DTSTART/value"/>
</xsl:call-template>
...
<xsl:template name="DATE">
   <xsl:param name="this-date"/>

   <xsl:call-template name="dt:format-date-time">
     <xsl:with-param name="year"
select='substring($this-date, 1, 4)' />
     <xsl:with-param name="month"
select='substring($this-date, 5, 2)'/>
     <xsl:with-param name="day"
select='substring($this-date, 7, 2)'/>
     <xsl:with-param name="hour"
select='substring($this-date, 10, 2)'/>
     <xsl:with-param name="minute"
select='substring($this-date, 12, 2)'/>
     <xsl:with-param name="second"
select='substring($this-date, 14, 2)'/>
     <xsl:with-param
name="time-zone"></xsl:with-param>
     <xsl:with-param name="format"
select="'%Y-%m-%dT %H:%M:%S'" />
   </xsl:call-template>
</xsl:template>

It's overkill if you just want to convert the date.
Perhaps you want to format dates in several ways...

Gary


Hewko, Doug wrote:

In my XML document, I have a date stored in ISO

format:

<LASTUPDATED

FORMAT="ISODATE">20010125</LASTUPDATED>

How can I convert this in my XSL file to dd/mm/yyy

format (with the
dashes)?

I am currently using the command:
			<td><xsl:value-of select="LASTUPDATED"/></td>

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

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

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