Yes. I have read that document. However, the issue isn't the SQL support, it is recognising a date constant in what is effectively a WHERE clause, because none of the usual ways of specifying a date constant (in other forms of SQL) are recognised, nor is it documented there. Because you could put a range of dates like 1984-01-01 to 1984-12-31 to work with a year if the format for inputting a date constant was available. On Fri, 2017-10-20 at 10:14 +0000, Alexandre Neto wrote: > Hi, > Vector Layer filtering SQL syntax is limited to the data provider. If > you are using a shapefile, then the provider is GDAL and you are > limited to this operands: > > http://www.gdal.org/ogr_sql.html > If you used Geopackage or Spatialite or PostGIS you would probably > have more datetime specific operands that might work with your field. > Alexandre Neto > > > A sex, 20/10/2017, 03:30, Patrick Dunford <blackwhite...@gmail.com> > escreveu: > > I have a shapefile table with 300,000 records of polygons that I > > want > > > > to filter for display on the map canvas. I want to use the field > > called > > > > "date" which is defined as a Qdate in the fields list in the > > > > shapefile's properties. > > > > > > > > The question is how to put in the filter string in the correct > > syntax > > > > to give me for example all the records that are for the calendar > > year > > > > of 1984. > > > >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
