[Qgis-user] Filter syntax for date fields

[Patrick Dunford]

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 <blackwhitekez at 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.
> > 
> > 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20171022/faec001f/attachment.html>