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

[Mark J. <mja...@go...>]

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 you can do this -

select trunc(A_DateTime), count(*)
from ATable
group by trunc(A_DateTime)

How would I achieve this using sparql in virtuoso?

Cheers
Mark