Format a date in XML via XSLT

by

Here are a couple of 1.0 templates that you can use:-

<xsl:template name="formatDate">
    <xsl:param name="dateTime" />
    <xsl:variable name="date" select="substring-before($dateTime, 'T')" />
    <xsl:variable name="year" select="substring-before($date, '-')" />
    <xsl:variable name="month" select="substring-before(substring-after($date, '-'), '-')" />
    <xsl:variable name="day" select="substring-after(substring-after($date, '-'), '-')" />
    <xsl:value-of select="concat($day, ' ', $month, ' ', $year)" />
</xsl:template>

<xsl:template name="formatTime">
    <xsl:param name="dateTime" />
    <xsl:value-of select="substring-after($dateTime, 'T')" />
</xsl:template>

Call them with:-

    <xsl:call-template name="formatDate">
        <xsl:with-param name="dateTime" select="xpath" />
    </xsl:call-template>

and

    <xsl:call-template name="formatTime">
        <xsl:with-param name="dateTime" select="xpath" />
    </xsl:call-template>

where xpath is the path to an element or attribute that has the standard date time format.

More Related Contents:

  1. Passing parameters to XSLT Stylesheet via .NET
  2. DateTime vs DateTimeOffset
  3. Parse DateTime with time zone of form PST/CEST/UTC/etc
  4. String was not recognized as a valid DateTime ” format dd/MM/yyyy”
  5. Algorithm to detect overlapping periods [duplicate]
  6. How to get difference between two dates in Year/Month/Week/Day?
  7. Serializing private member data
  8. How do I get the last day of a month?
  9. Measuring code execution time
  10. Get Month name from month number
  11. How do I represent a time only value in .NET?
  12. Serialize Property as Xml Attribute in Element
  13. .net XML Serialization – Storing Reference instead of Object Copy
  14. What is the difference between Linq to XML Descendants and Elements
  15. How to decode string to XML string in C#
  16. How to store data locally in .NET (C#) [closed]
  17. Parse C# string to DateTime
  18. How do I get the AM/PM value from a DateTime?
  19. Read a XML (from a string) and get some fields – Problems reading XML
  20. Error Deserializing Xml to Object – xmlns=” was not expected
  21. XmlTextReader vs. XDocument
  22. Convert String to Date in .NET if my incoming date format is in YYYYMMDD
  23. How to parse and generate DateTime objects in ISO 8601 format
  24. Removing nodes from an XmlDocument
  25. DateTime conversion from string C#
  26. DateTime.Parse(“2012-09-30T23:00:00.0000000Z”) always converts to DateTimeKind.Local
  27. How can I remove empty xmlns attribute from node created by XElement
  28. How to transform XML as a string w/o using files in .NET?
  29. LINQ Query to Convert string to datetime
  30. XSLT transformation on Large XML files with C#

Leave a Comment