This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: date format




stevenson wrote:

> I have a date coming from database in this form:  yyyy - mm - dd
> But i want to format it in my xsl document to become dd/mm/yy.
> 
> How can i achieve this. 
> 
> Can anyone assist me?
> 
> 
hello,

assumed you have got elements like <olddate>yyyy - mm - dd</olddate>

something like


  <xsl:template match="olddate">
    <date>
      <xsl:value-of select="substring(.,3,2)" />/<xsl:value-of select="substring(.,13,2)" />/<xsl:value-of select="substring(.,8,2)" />
    </date>
  </xsl:template>

should work.


substring(string, nr1, nr2) returns the substring of string, starting at nr1
with length nr2.

(Jeni probably provided a more elegant solution ;) )

-you might want to check out the xsl-list at mulberrytech.com, there the specialists hang out (if you don't mind the traffic).


cheers,
Markus



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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]