Re: [gdal-dev] OGR Shapefile SQL with date in where clause

2011-02-07 Thread Even Rouault
Le lundi 07 février 2011 16:35:21, Nicolas Simon a écrit : > Paolo, > > I have no error on the command line... and an empty result in the > destination file. I'm using GDAL 1.6.1, could it be the reason ? Yes, you likely need to upgrade to latest version as there have been a number of fixes rela

RE: [gdal-dev] OGR Shapefile SQL with date in where clause

2011-02-07 Thread Nicolas Simon
À : Nicolas Simon > Cc : gdal-dev@lists.osgeo.org > Objet : Re: [gdal-dev] OGR Shapefile SQL with date in where clause > > > On Mon, Feb 7, 2011 at 4:08 PM, Nicolas Simon > wrote: > > Hello, > >     I would like to extract feature from a shapefile > layer base

Re: [gdal-dev] OGR Shapefile SQL with date in where clause

2011-02-07 Thread Paolo Corti
On Mon, Feb 7, 2011 at 4:08 PM, Nicolas Simon wrote: > Hello, >     I would like to extract feature from a shapefile layer based on a > Date field. > >     But I don't know how to format date value > >     Here is a defect command > > ogr2ogr -f "ESRI Shapefile" extrait.shp fulldataset

[gdal-dev] OGR Shapefile SQL with date in where clause

2011-02-07 Thread Nicolas Simon
Hello, I would like to extract feature from a shapefile layer based on a Date field. But I don't know how to format date value Here is a defect command ogr2ogr -f "ESRI Shapefile" extrait.shp fulldataset.shp -sql "select * from fulldataset where VIS