Display current date/time in xsl

[JayaSiji Gopal]

I have an xml document which uses xsl for transformation to excel.

in the xsl document, i need to also write code to display the current date/time in the format - {$DD-Mmm-YYYY 24HH:MN:SS TZN}" timestamp unwrapped. TZN is user's time zone.

I actually get the idea to use xs:datetime, however, i am unfamiliar with the usage in xsl. Could someone please help me with the syntax?

[Paul Clapham]

There isn't any function in XSLT 1.0 to produce the current timestamp.

[Dmitrij Beloborodov]

For XSLT 2.0 you have a wealth of date functions, i.e.:

<xsl:value-of  select="current-dateTime()"/>

as well as current-date() and current-time().

For XSLT 1 you'll have to use the dates-and-times EXSLT extension package. Here's a usage example for XSLT 1:

<xsl:stylesheet ... 
    xmlns:ex="http://exslt.org/dates-and-times" 
    extension-element-prefixes="ex">

    ...

       <xsl:value-of select="ex:date-time()"/>
    ...
</xsl:stylesheet>

The only problem is get date in specific format.

[Dmitrij Beloborodov]

This solution worked out for me. It might help you:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
xmlns:java="http://xml.apache.org/xslt/java"
exclude-result-prefixes="java">
...
<xsl:value-of select="java:format(java:java.text.SimpleDateFormat.new('yyyy.MM.dd'), java:java.util.Date.new())" />
...
</xsl:stylesheet>