Malcolm,
We've fixed it. Try the latest development build:
http://modis.ispras.ru/FTPContent/sedna/development/
Ivan Shcheklein,
Sedna Team
Hi Malcolm,
>
> Seems to be a bug. Will fix it ASAP.
>
> Thank you for your report!
>
> Ivan Shcheklein,
> Sedna Team
>
>
> Build: sedna3.5.102
>>
>> I'm trying to calculate the number of days between 2 date values.
>>
>> I noticed that SEDNA returns the number of days when doing date
>> subtraction,
>> which makes this easy.
>>
>> However, the calculations seem to have a problem.
>>
>> In the sample XML data below, the difference between TxnDate and DueDate
>> is
>> 1, and the difference between 2011-03-12 and today is 12. The odd thing
>> is
>> that SEDNA gets the calculations correct sometimes with other situations.
>>
>> Am I doing something wrong? Is there another approach I should take?
>>
>> Sample data:
>> <?xml version="1.0" encoding="ISO-8859-1"?>
>> <Bills>
>> <Bill>
>> <TxnNumber>1265</TxnNumber>
>> <VendorName>Patton Hardware Supplies</VendorName>
>> <PayerName>Patton Hardware Supplies</PayerName>
>> <TxnDate>2011-03-12</TxnDate>
>> <DueDate>2011-04-11</DueDate>
>> <TotalAmt>500.00</TotalAmt>
>> <SalesTermName>Net 30</SalesTermName>
>> <Status>Paid</Status>
>> </Bill>
>> </Bills>
>>
>> Query:
>> let $dataset := doc("bills.xml")
>> for $element in $dataset/Bills/Bill
>> let $now := xs:date(fn:current-date())
>> let $age := xs:date(fn:current-date())-xs:date($element/DueDate)
>> let $txn_due_diff :=
>> xs:date($element/DueDate)-xs:date($element/TxnDate/text())
>>
>> return(<row>{$element/VendorName}{$element/TxnDate}{$element/DueDate}<now>{$
>>
>> now}</now><age>{$age}</age><txn_due_diff>{$txn_due_diff}</txn_due_diff>{$ele
>> ment/Status}</row>)
>>
>> Results:
>> <row>
>> <VendorName>Patton Hardware Supplies</VendorName>
>> <TxnDate>2011-03-12</TxnDate>
>> <DueDate>2011-04-11</DueDate>
>> <now>2011-12-23-05:00</now>
>> <age>P12D</age>
>> <txn_due_diff>P-1D</txn_due_diff>
>> <Status>Paid</Status>
>> </row>
>>
>>
>> Thanks,
>> Malcolm
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Write once. Port to many.
>> Get the SDK and tools to simplify cross-platform app development. Create
>> new or port existing apps to sell to consumers worldwide. Explore the
>> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
>> http://p.sf.net/sfu/intel-appdev
>> _______________________________________________
>> Sedna-discussion mailing list
>> Sedna-discussion@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>>
>
>
------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
