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

Nicolas Simon nicolas.simon at spw.wallonie.be
Mon Feb 7 10:08:23 EST 2011


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 VISTERRAIN = '2010/12/07' " 

	Help will be welcome.
	
	Thank you

	Nicolas Simon


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20110207/acada065/attachment-0001.html


More information about the gdal-dev mailing list