This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
Re: date format
- From: Markus Spath <mspath at arcor dot de>
- To: stevenson at epr dot footman-walker dot com
- Cc: bry at itnisk dot com, jeni at jenitennison dot com, andrew at thebristoldirectory dot com, xml at p2p dot wrox dot com, xsl-list at lists dot mulberrytech dot com
- Date: Thu, 07 Feb 2002 00:17:47 +0100
- Subject: [xsl] Re: date format
- References: <OOEMLIMIIBLDEKIKOHJAIEACCBAA.stevenson@epr.footman-walker.com>
- Reply-to: xsl-list at lists dot mulberrytech dot com
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