I am trying to write a query that will return my all CareerStation objects that are associated with Arsenal FC. Then I want to be able to get the start and end dates of these CareerStations, currently I can only get the start date. It may be that only the start date is in the DB but this doesn't make much sense to me. Also I would like to know if there is a way of formatting the date so to remove the parts that aren't the actual year.
Thanks in advance for any pointers.
PREFIX p: <http://dbpedia.org/property/>
select *
where {
?careerStation <http://dbpedia.org/ontology/team>
<http://dbpedia.org/resource/Arsenal_F.C.> .
?careerStation <http://dbpedia.org/ontology/years> ?year
}
order by ?player