SSDN - Subtract times

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Conferences

	Stylus Studio Feature Requests (1192)
	Stylus Studio Technical Forum (14621)
	Website Feedback (249)
	XSLT Help and Discussion (7625)
	XQuery Help and Discussion (2016)
	Issue with Processing Instruct... (1)
	problem converting json to XML... (2)
	Problem base64 decoding string... (3)
	Problems posting multipart for... (5)
	trouble with download of price... (2)
	Problem with http-post not bei... (3)
	path problem, xps_file:writeAl... (9)
	Xquery update support? (2)
	problem with Stylus studio try... (5)
	adding dtd reference to xml ou... (4)
	xquery escaping ambarsand when... (3)
	Whitespace problem when return... (5)
	Problem with namespace prefix ... (5)
	Sending via SFTP returns unexp... (1)
	Query and Sftp clent (4)
	xquery and try - catch (3)
	Query + ddtek:http-post optio... (5)
	Example files referenced in do... (3)
	Automatic Error Detection and ... (3)
	Working with result of ddtek:h... (2)
	[1-20] [21-40] [41-60] Next
	Stylus Studio FAQs (159)
	Stylus Studio Code Samples & Utilities (364)
	Stylus Studio Announcements (113)

Topic

(Deleted User)

Subject: Subtract times
Author: (Deleted User)
Date: 14 Nov 2008 09:55 AM

Hi you all,

I want to subtract two time fields. Googling learned me that the op:subtract function would work and that if you add this namespace prefix you can just deduct to variables. I think I am close to a solution with the code below, however it keeps telling me:

Static type error. Types 'element(DateEnd, xs:anyType)' and 'element(DateStart, xs:anyType)' are invalid argument types for binary operator '-'.

though I have associated a schema (right mouse button on doc node in source doc of xquery) in which these two fields are defined as xsd:date fields. Can you assist?

declare variable $arg1 as element(DateStart) external;
declare variable $arg2 as element(DateEnd) external;

<eExact xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:op="http://www.w3.org/2001/12/xquery-operators">
<Requests>
<Request>
<DateStart>
{$arg2 - $arg1}
</DateStart>
</Request>
</Requests>
</eExact>

Regards,

Cynthia

Minollo I.

Subject: Subtract times
Author: Minollo I.
Date: 14 Nov 2008 10:08 AM

What XQuery processor is reporting the error you mentiond running that XQuery?

(Deleted User)

Subject: Subtract times
Author: (Deleted User)
Date: 14 Nov 2008 03:45 PM

Hi Minollo,

Processor is DataDirect Xquery. I am also trying this version to bind a variable to an xml element, but there are some mistakes there as well:

<eExact xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="eExact-Schema.xsd" xmlns:op="http://www.w3.org/2001/12/xquery-operators">
<Requests>
<Request>
for $arg1 in doc('file:///e:/Synergy_ASP/HR/Verlofaanvragen/Workflow_Verlof_basis.xml')/root/row/DateStart
return
<DateStart>
doc('file:///e:/Synergy_ASP/HR/Verlofaanvragen/Workflow_Verlof_basis.xml')/root/row/DateStart
</DateStart>
for $arg2 in doc('file:///e:/Synergy_ASP/HR/Verlofaanvragen/Workflow_Verlof_basis.xml')/root/row/DateEnd
return
<DateEnd>
doc('file:///e:/Synergy_ASP/HR/Verlofaanvragen/Workflow_Verlof_basis.xml')/root/row/DateEnd
</DateEnd>
<Diff>
{$arg2 - $arg1}
</Diff>
</Request>
</Requests>
</eExact>

(Deleted User)

Subject: Subtract times
Author: (Deleted User)
Date: 14 Nov 2008 05:42 PM

Hi again,

I succeeded in declaring my variables, but the actucal subtraction doesn't work yet, what am I missing?

for $row in doc('file:///e:/Synergy_ASP/HR/Verlofaanvragen/Workflow_Verlof_basis.xml')/root/row
let $arg1 := xs:time($row/DateStart),
$arg2 := xs:time($row/DateEnd)
return
<eExact xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="eExact-Schema.xsd" xmlns:op="http://www.w3.org/2001/12/xquery-operators">
<Requests>
<Request>
<DateStart>
{$arg2-$arg1}
</DateStart>
<DateEnd/>
<Diff>
</Diff>
</Request>
</Requests>
</eExact>

Thanks!

Cynthia

Minollo I.

Subject: Subtract times
Author: Minollo I.
Date: 14 Nov 2008 08:03 PM

What is the error you are getting? Maybe the format in the elements you are interpreting as xs:time is not correct? The following examples may help:

xs:time('23:23:23') - xs:time('23:22:23')
result: PT1M

xs:date("2008-11-15")-xs:date("2008-11-14")
result: P1D

xs:dateTime("2008-11-15T23:12:23")-xs:dateTime("2008-11-14T23:11:23")
result: P1DT1M

The returned values are xs:duration types; you can use various functions to handle xs:duration, like hours-from-duration(), days-from-duration(), ...; a word of caution; those functions are specified to be less smart than you might think: hours-from-duration("P1D") is 0 (not 24 as I expected); days-from-duration("P1D") is 1.

(Deleted User)

Subject: Subtract times
Author: (Deleted User)
Date: 15 Nov 2008 03:56 AM

Morning!

Ok, waking up and of course right away curious if there is a post. Now got the answer, cause I realized my types were xs:time but if was just giving back <DateStart>11:00:00-10:00:00</DateStart>. Moved the subtraction to the top of my xquery file, assigned the subtraction outcome to $arg3 and placed {$arg3} in my xml tag. Et voila!

Thank you so much!

Cynthia

for $row in doc('file:///e:/Synergy_ASP/HR/Verlofaanvragen/Workflow_Verlof_basis.xml')/root/row
let $arg1 := xs:time($row/DateStart),
$arg2 := xs:time($row/DateEnd),$arg3:= ($arg2)-($arg1)

return

<eExact xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="eExact-Schema.xsd" xmlns:op="http://www.w3.org/2001/12/xquery-operators">
<Requests>
<Request>
<DateStart>
</DateStart>
<DateEnd/>
<Diff>
{$arg3}
</Diff>
</Request>
</Requests>
</eExact>

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.