xsl-list
[Top] [All Lists]

Re: date arithmetic

2004-09-01 10:27:24
David Sinclair asked:
I want to add 6 months to a date (in xslt2.0) but cant find any
references on how to do this.  After much googling I  tried 
something like:

   <xsl:value-of select="xs:date($reviewDate) + 
xs:duration('P0Y0M6DT0H00M')"/>
   
But the processor (Saxon 8.0)  says that date arithmetic is not 
supported on xs:duration.   If I am barking up the right 
tree, then what 
are the supported subtypes?  Hope someone can help,

Mike Kay replied:
xs:date($reviewDate) + xdt:yearMonthDuration('P6M')

Just to flesh out Mike's reply a bit...

xs:duration is defined by XML Schema as a number of years, months,
days, hours, minutes and seconds. The trouble is that it's not
possible to give definitive answers to comparisons when you have
durations that contain both years or months and days, hours, minutes
or seconds. For example, which is longer, one month or 30 days? In
technical terms, xs:duration is "partially ordered".

XPath 2.0 dodges the question by only supporting two "totally ordered"
subtypes of xs:duration: durations that only involve years and months
(xdt:yearMonthDuration) and durations that only involve days, hours,
minutes and seconds (xdt:dayTimeDuration).

If you want to add a duration that combines the two subtypes, you need
to add one and then the other, as in:

  (current-date() + xdt:yearMonthDuration('P1Y')) +
  xdt:dayTimeDuration('P1D')

(Of course, the order in which you add them makes a difference to the
result...)

Note that you don't have to include a component if there are 0 of
them: if you have 0 days in a duration, you don't need to put '0D' in
it.

Cheers,

Jeni

---
Jeni Tennison
http://www.jenitennison.com/



<Prev in Thread] Current Thread [Next in Thread>