Re: [xsl] Date/Time in XSLT and/or XPath

Subject: Re: [xsl] 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 &gt;= $StartTime and DtTmEnd
&lt;= $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



Current Thread