Difference (duration) of two xsd:dateTime literals

[arrascue]

Hello,

Is there a way to get the difference between two date times in RDF4J?

SELECT *
WHERE {
    bind("2023-09-14T06:37:46.225Z"^^xsd:dateTime as ?t1)
    bind("2025-07-29T10:06:59.109Z"^^xsd:dateTime as ?t2)
    bind(?t2 - ?t1 as ?diff)
}

?diff returns empty.

Thank you very much

[hmottestad]

I'm not sure if this is possible. The SPARQL standard only seems to support numbers when using subtraction.

You can use < and > to check which is smaller, but it won't give you the diff.

I couldn't find an epoch function either. Which would have made it possible to convert the date time to a number you could diff.

[hmottestad]

You could implement a custom function if you want: https://rdf4j.org/documentation/tutorials/custom-sparql-functions/

[arrascue]

Thank you!