Hi Peter,
Can you please provide details of the Virtuoso Server being used ?
Having inserted a datetime value into my Virtuoso 6 instance the
select query does return the datetime value as inserted:
SQL> sparql insert in graph <http://mygraph.com> { <http://
www.dajobe.org/foaf.rdf#i> <http://purl.org/dc/elements/1.1/date>
<2009-07-08T00:50:36Z> };
callret-0
VARCHAR
________________________________________________________________________
_______
Insert into <http://mygraph.com>, 1 triples -- done
1 Rows. -- 155 msec.
SQL> sparql select * from <http://mygraph.com> where {?s ?p ?o};
s
p
o
VARCHAR
VARCHAR
VARCHAR
________________________________________________________________________
_______
http://www.dajobe.org/
foaf.rdf#i http://
purl.org/dc/elements/1.1/
date 2009-07-08T00:50:36Z
1 Rows. -- 155 msec.
SQL>
Is this how you are performing your insert ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 8 Jul 2009, at 02:00, Peter Ansell wrote:
Hi all,
I am trying to figure out why when I insert xsd:dateTime typed
literals in the form "2009-07-08T00:50:36Z", they come out of
SELECT sparql queries as "2009-07-08T00:50:36.000" and they come
out in CONSTRUCT sparql queries as "2009-07-08T00:50:36.000+10:00".
I think for select queries everything is working, but I don't know
why there is an arbitrary 10:00 added to the end of the value,
especially since the time value isn't changed, and if interpreted
literally I could imagine it being interpreted as
"2009-07-07T14:50:36Z" if you thought you needed to take 10 hours
off to get to the Z time offset. Simply put, it is a bug somewhere
at minimum that SELECT queries aren't consistent with CONSTRUCT
queries.
Is there anywhere that this can be configured so that it keeps
putting dateTime out using the "2009-07-08T00:50:36Z" style instead
of either of the other two styles and then the results from SELECT
and CONSTRUCT can both be used with the same style that I am using
in the RDF I am inserting.
Cheers,
Peter
______________________________________________________________________
______________
Access Yahoo!7 Mail on your mobile. Anytime. Anywhere.
Show me how: http://au.mobile.yahoo.com/mail
----------------------------------------------------------------------
--------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited
time,
vendors submitting new applications to BlackBerry App World(TM)
will have
the opportunity to enter the BlackBerry Developer Challenge. See
full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
