Solved

Change date format in xslt

Posted on 2009-04-02
3
602 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Most of the sites are being standardized with W3C Web Standards. W3C provides lot of web standard services to the web. They have the web specification, process and documentation for all the web standards. You can apply HTML, CSS and Accessibility st…
The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now