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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
