Solved

Change date format in xslt

Posted on 2009-04-02
3
608 Views
Last Modified: 2013-11-18
Hi,

I'm using xslt to display date from xml
In xml the date is like "2009-02-11T15:55:20.283-08:00" , which i'm reading from xsl.
I want to change the format of date to "02-11-2009" in xsl.


How can i do that

Thanks and Regards
Puneet
XML:
 
<a>
<b id="1">
  <date>2009-02-11T15:55:20.283-08:00</date>
</b>
<b id="2">
  <date>2009-02-21T10:55:20.283-08:00</date>
</b>
 
 
and my xsl is 
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="UTF-8"/>
<xsl:template match="/">
<html>
<head><title>Oa</title><link rel="stylesheet" type="text/css" />
</head>
<body  bgcolor="#808080">
<TR>
<xsl:for-each select="a/b">
<TD width="10%" align="center"><xsl:value-of select="date"/></TD> 
</TR>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

Open in new window

0
Comment
Question by:PuneetKSaxena
  • 2
3 Comments
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 500 total points
ID: 24047436
try this
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output method="html" encoding="UTF-8"/>
    <xsl:template match="/">
        <html>
            <head><title>Oa</title><link rel="stylesheet" type="text/css" />
            </head>
            <body  bgcolor="#808080">
                <TR>
                    <xsl:for-each select="a/b">
                        <TD width="10%" align="center">
                            <xsl:value-of select="substring-before(substring-after(date, '-'), '-')"/>
                            <xsl:text>-</xsl:text>
                            <xsl:value-of select="substring-before(substring-after(substring-after(date, '-'), '-'), 'T')"/>
                            <xsl:text>-</xsl:text>
                            <xsl:value-of select="substring-before(date, '-')"/>
                        </TD> 
                        </xsl:for-each>
                </TR>
            </body>
        </html>
    </xsl:template>
</xsl:stylesheet>

Open in new window

0
 

Author Closing Comment

by:PuneetKSaxena
ID: 31565681
Thats perfect.

Thanks a lot
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24047640
welcome
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

What is Node.js? Node.js is a server side scripting language much like PHP or ASP but is used to implement the complete package of HTTP webserver and application framework. The difference is that Node.js’s execution engine is asynchronous and event…
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question