[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Converting dayTimeDuration to yearMonthDuration

Subject: Re: Converting dayTimeDuration to yearMonthDuration
From: Gary Stewart <the.stewarg@xxxxxxxxx>
Date: Wed, 18 Jan 2006 15:23:51 +0000
subtract dates yielding yearmonthduration
On 18/01/06, Michael Kay <mike@xxxxxxxxxxxx> wrote:
>
> There was a function to do this at one stage - something like
> subtract-dates-yielding-yearMonthDuration - but we took it out because we
> had trouble defining exactly what it should do. (If you were born on 29 Feb
> 1980, how old are you on 28 Feb 2006?)

Yeah I saw that on one of the older specs. I see why it was taken out.

> ((current-date() - xsd:date(birthdate)) div xdt:dayTimeDuration('P1D'))
>    idiv 365.242199
>    * xdt:yearMonthDuration('P1Y')
>
> But that may give small errors at the boundaries (i.e. on someone's
> birthday).

Thanks that is what I'll use. It's information rather than system
critical stuff.

> The alternative, I think, is to extract the year/month/day components of
the
> two dates and do the calculation yourself.

OK. I'll keep that in mind in the event that people complain about the
wrong age (unlikely though).

Thanks again,

Gary

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.