Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Change date format in xslt

Posted on 2009-04-02
3
Medium Priority
?
613 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 2000 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
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:
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Suggested Courses

564 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