XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Ron BernardSubject: Format Datetime with xslt
Author: Ron Bernard
Date: 26 Aug 2009 05:49 PM
Hello. We have a table that contains a dateTime value in the following format: Wed Aug 26 15:21:45 CDT 2009.

We would like to convert this to the following format: 08/26/2009 1521. Is there a way to do this with xslt. I've tried the following:

<xsl:template xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:variable name="jsximpact">
<xsl:value-of select="{0}"/>
</xsl:variable>
<xsl:value-of select="format-dateTime($jsximpact, '[M01]/[D01]/[Y04] [H][m]')"/>
</xsl:template>

But this does not work. Any help would be appreciated.

Thanks

Postnext
(Deleted User) Subject: Format Datetime with xslt
Author: (Deleted User)
Date: 02 Sep 2009 12:15 PM
Hi Ron,
in order to do the conversion you need access to a Java extension function; does your XSLT processor support that?

Alberto

Posttop
Jonathan ByrdSubject: Format Datetime with xslt
Author: Jonathan Byrd
Date: 27 Jan 2010 05:19 PM
I just wanted to mention...

I'm using the latest Saxon free-ware parser, 9.0.2 i think and it is giving me dateTime values that are not consistent with the W3C spec.

my pattern is:

format-dateTime($somedatetime, '[M01]/[D01]/[Y0001] [h01]:[m01]:[s01] [PN]')

The issue is that its returning "P.M." or "A.M." instead of AM or PM (without the periods). The W3C spec says it should be without periods. I only bring this up because the A.M. value breaks some convertdate functions; especially CDate() in VB/VBScript.

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.