Hi Timo, This problem and been recreated and reported to development for resolution ...
Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 4 May 2011, at 14:52, Timo Westkämper wrote: > 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 > > ------------------------------------------------------------------------------ > WhatsUp Gold - Download Free Network Management Software > The most intuitive, comprehensive, and cost-effective network > management toolset available today. Delivers lowest initial > acquisition cost and overall TCO of any competing solution. > http://p.sf.net/sfu/whatsupgold-sd_______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users