SQL astuces

12 articles

Comment rechercher sur un intervalle de dates?

Un exemple vaut parfois mieux que de longues explications : SELECT biblio.datecreated AS Date_creation, biblio.title AS Titre, biblio.author AS Auteur, items.itemcallnumber AS Cote FROM items , biblio, biblioitems WHERE biblio.datecreated BETWEEN <<date de creation BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> AND […]