Hi.

Sorry for my amount of mails on this list, but I had really lots of troubles with Virtuoso lately.

I found a reproducable sequence which presents one of my problems with dateTime literal handling in Virtuoso :


* Insert the following triples via the ttlp function :

ttlp ('<http://test> <http://test1> "2000-01-01T00:00:00.000Z"^^<http://www.w3.org/2001/XMLSchema#dateTime> . <http://test> <http://test2> "2000-01-01T00:00:00.000+02:00"^^<http://www.w3.org/2001/XMLSchema#dateTime> .', '', 'http://test', 0);

* Execute the following query via the Interactive SQL window :

sparql select * where { <http://test> ?p ?o }

The results are :

 http://test1     2000-01-01 00:00:00
 http://test2     2000-01-01 00:00:00

* Execute the same query via the SPARQL query form :

select * where { <http://test> ?p ?o }

The results are :

http://test1    2000-01-01T00:00:00Z
http://test2    2000-01-01T00:00:00+02:00


I am having the same issue when using SPARQL via JDBC. The timezone offset is ignored when using SPARQL via JDBC or the Interactive SQL form.

Br,
Timo Westkämper

Reply via email to