[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[Recent Entries]
[Reply To This Message]
Re: Date/Time in XSLT and/or XPath
Subject: Re: Date/Time in XSLT and/or XPath
From: "J.Pietschmann" <j3322ptm@xxxxxxxx>
Date: Thu, 16 May 2002 00:34:25 +0200
|
Faroukh Fekravar wrote:
Hi,
I need to compare date and time, something like below
<xsl:for-each select="../aaa/bbb[DtTmStart >= $StartTime and DtTmEnd
<= $EndTime]">
All four dates are in in format like
5/2/2000 3:00:00 AM
or
5/2/2000 (assumed midnight)
Is there anyway to do that (formatting, etc ..)
Check the XPath spec for the substring-before() and
substring-after() functions. Use them to extract
year, month and day and the time value from your
string. You can either compare these values directly,
or concat them to ISO 8601 format, whic is easier
to compare.
If you still can, get the date/time values in your
source XML converted or produced in ISO 8601 format,
you can compare them directly (as strings), which
will make your life much easier. You can easily format
these values into your localized format for presentation
using substring(), or check out the EXSLT date/time
formatting extension functions.
J.Pietschmann
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format
RSS 2.0 |
|
Atom 0.3 |
|
|