Ok, seems that it's how XQuery should work:
http://www.w3.org/TR/xpath-functions/#func-subtract-dates
*op:subtract-dates($arg1 as xs:date, $arg2 as xs:date) as xs:dayTimeDuration
*
http://www.w3.org/TR/xpath-functions/#func-years-from-duration
*If $arg is an xs:dayTimeDuration returns 0. *
It's seems to me that you can't get correctly number of years from number
of days between two dates.
On Thu, Sep 13, 2012 at 11:13 PM, <[email protected]> wrote:
> Currently we use the latest version 3.5
>
> Thanks,
>
> Willy
>
> On Thu, 13 Sep 2012 22:58:48 +0400, Ivan Shcheklein
> <[email protected]> wrote:
> > Hi Willy,
> >
> > Which version of Sedna do you use?
> >
> > Ivan Shcheklein,
> > Sedna Team
> >
> > Hello all,
> >
> > I’m confused by values return by the years-from-duration function.
> >
> > In the following code, $age duration is equal to P3071D which is a
> > correct value.
> >
> > But years-from-duration function returns 0, and month-from-duration
> > also returns 0. Only days-from-duration return 3071.
> >
> > let $d1 := xs:date('2001-10-03')
> > let $d2 := xs:date('2010-03-01')
> > let $age := xs:duration($d2 - $d1)
> >
> > let $ageY := years-from-duration($age)
> > return {$ageY}
> >
> > It sounds like a bug in the xQuery interpreter ?
> >
> > Thank you for your help,
> >
> > Willy
> >
> >
> >
> ------------------------------------------------------------------------------
> > Live Security Virtual Conference
> > Exclusive live event will cover all the ways today's security and
> > threat landscape has changed and how IT managers can respond.
> > Discussions
> > will include endpoint security, mobile security and the latest in
> > malware
> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > [1]
> > _______________________________________________
> > Sedna-discussion mailing list
> > [email protected] [2]
> > https://lists.sourceforge.net/lists/listinfo/sedna-discussion [3]
> >
> >
> >
> > Links:
> > ------
> > [1] http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> > [2] mailto:[email protected]
> > [3] https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
