Rich; Not sure if the difference in expectation is
with the version TopBraid being used, but using 4.3,
smf:duration() takes xsd:dateTime and will return down to the
milliseconds. As an example, to get the number of seconds between
a dateTime property and the current xsd:dateTime, you can use the
following:
SELECT ?dur
WHERE
{ ?s ex:dt ?time
BIND(smf:duration("s", ?time, now()) AS ?dur)
}
-- Scott
On 2/11/2014, 6:51 PM, Rich Keller
wrote:
Scott: I'm aware of the SPARQL and TopBraid
functions you mention. But to my knowledge, these functions do
not operate on duration literals like P0Y0M0DT22H0M0.000S, which
was returned by my query subtracting two xsd:time or
xsd:dateTime literals (see original post). As I mentioned,
smf:duration seems to take two xsd:date variables as input,
which means it is not suitable for determining the duration
between arbitrary times.
Rich
On Tuesday, February 11, 2014 9:39:40 AM UTC-8, Scott Henninger
wrote:
Rich,
there are a number of SPARQL and TopBraid functions that
work on xsd:time and xsd:dateTime for SPARQL, see http://www.w3.org/TR/sparql11-query/#func-date-time,
including year(), month(), day(), hours(), timezone(),
etc.
TopBraid also has functions for duration, formatting date
strings, etc. I.e. you can convert a dateTime string to a
date string using dateFormat(). See TopBraid Composer
Help TopBraid Composer > Reference > Functions
Overview
-- Scott
On 2/11/2014, 10:40 AM, Rich Keller wrote:
Hi. I have been trying to do some temporal
arithmetic in SPARQL and have stumbled upon what I
believe are time periods or time intervals. For example
SELECT ?a ?aa
WHERE {
BIND (("08:15:00"^^xsd:time - "10:15:00"^^xsd:time) AS
?a)
BIND (("2012-09-08T08:15:00"^^xsd:dateTime -
"2012-09-07T10:15:00"^^xsd:dateTime) AS ?aa)
}
Results:
?a -> -P0Y0M0DT2H0M0.000S (negative 2 hours)
?aa -> P0Y0M0DT22H0M0.000S (positive 22 hours)
My question: Is there any way to operate on these time
periods? In particular, suppose I want to convert the
length of these these periods into seconds or minutes.
smf:duration does something similar, but it works on
xsd:date values, and not time periods. If smf:duration
took xsd:dateTime or xsd:time arguments, that would be
helpful.
Do you have any pointers to functions that extract
information from these time periods? I suppose I can
figure a way to do the arithmetic myself using days(),
hours(), minutes() functions, but I would prefer to
avoid that.
Thanks, Rich
Using TBC-SE 4.3.0
--
-- You received this message because you are subscribed to
the Google
Group "TopBraid Suite Users", the topics of which include
Enterprise Vocabulary Network (EVN), TopBraid Composer,
TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web
Pages and SPIN.
To post to this group, send email to
topbrai...@googlegroups.com
To unsubscribe from this group, send email to
topbraid-user...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/topbraid-users?hl=en
---
You received this message because you are subscribed to
the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to topbraid-user...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
-- You received this message because you are subscribed to the
Google
Group "TopBraid Suite Users", the topics of which include
Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid
Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN.
To post to this group, send email to
[email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/topbraid-users?hl=en
---
You received this message because you are subscribed to the Google
Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
--
-- You received this message because you are subscribed to the Google
Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN.
To post to this group, send email to
[email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/topbraid-users?hl=en
---
You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
|
