Subject: Re: [xsl] Date/Time in XSLT and/or XPath From: "J.Pietschmann" <j3322ptm@xxxxxxxx> Date: Thu, 16 May 2002 00:34:25 +0200 |
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.
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] Date/Time in XSLT and/or , Joerg Heinicke | Thread | RE: [xsl] convert string to xml rec, Stuart Celarier |
Re: [xsl] Date/Time in XSLT and/or , Joerg Heinicke | Date | RE: [xsl] Converting a string to sm, Stuart Celarier |
Month |