Solved

Change date format in xslt

Posted on 2009-04-02
3
610 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

726 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