Re: [Virtuoso-users] date manipulation for xsd types within sparql

2010-06-29 Thread Ivan Mikhailov
Hello Mark, Oops, I've found a bug. That's not a pure SPARQL, and it can't be expressed in pure 1.0, but it should work in Virtuoso's SPARQL/BI sparql select (xsd:date(?a_dt)), count(*) from where { ?s ?a_dt } group by (xsd:date(?a_dt)) Unfortunately that worked for bif:year(?dt) and bif:mont

[Virtuoso-users] date manipulation for xsd types within sparql

2010-06-29 Thread Mark James
Hi, I was wondering if there was functionality available within sparql to manipulate columns of type xsd:date, xsd:time and xsd:dataTime. The most important one to me right now is the ability to truncate a dateTime column to only a date in order to perform a group by on this column. Eg in oracle