Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sparql year function

String requete7String = 
            "PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> "
          + "PREFIX dc: <http://purl.org/dc/elements/1.1/> "
          + "PREFIX rss: <http://purl.org/rss/1.0/> "
          + "PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> "
          + "SELECT ?item "
          + "FROM <http://www.w3.org/2001/sw/SW-FAQ-feed.rdf> "
          + "WHERE { "
          + "  ?item rdf:type rss:item . "
          + "  ?item dc:date ?dateString ."
          + "  bind(strdt(?dateString, xsd:dateTime) as ?date) "
          + "  FILTER (year(?date) = 2007) "
          + "}";
Comment

PREVIOUS NEXT
Code Example
Sql :: cahnge column name apex oracle 
Sql :: dump only data 
Sql :: SQL CHECK Constraint in Existing Table 
Sql :: sql server separar numeros por comas miles 
Sql :: insert column rake 
Sql :: SQL Query Orderby Two or More Columns and by number of characters 
Sql :: bitmap join index 
Sql :: bidirectional outer join sql 
Sql :: start whith system mysql 
Sql :: drop-toys-table 
Sql :: join mysql 
Sql :: replace sqlalchemy 
Sql :: oracle date winter time 
Sql :: <sql:datasource var="Snapsho" 
Sql :: list foreign user mapping postgres 
Sql :: sql column as header 
Sql :: MSSQL MAX VALOR 
Sql :: oracle optional field procedure 
Sql :: sql server 2012 create or alter procedure 
Sql :: homebrew/sqlitestudio 
Sql :: sqlite database file android studio 
Sql :: count in spqarql 
Sql :: sql select upcoming birthdays 
Sql :: sqlite 
Sql :: while in plsql 
Sql :: convert sql query to laravel eloquent 
Sql :: bigquery javascript 
Sql :: python connect to mysql in settings.py 
Csharp :: c# get current directory 
Csharp :: unity check collider layer 
ADD CONTENT
Topic
Content
Source link
Name
7+5 =