<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>OGR Shapefile SQL with date in where clause</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hello,</FONT>
<BR> <FONT SIZE=2 FACE="Arial">I would like to extract feature from a shapefile layer based on a Date field.</FONT>
</P>
<P> <FONT SIZE=2 FACE="Arial">But I don't know how to format date value </FONT>
<BR>
<BR> <FONT SIZE=2 FACE="Arial">Here is a defect command </FONT>
<BR>
<BR><FONT SIZE=2 FACE="Arial">ogr2ogr -f "ESRI Shapefile" extrait.shp fulldataset.shp -sql "select * from fulldataset where VISTERRAIN = '2010/12/07' " </FONT></P>
<P> <FONT SIZE=2 FACE="Arial">Help will be welcome.</FONT>
<BR>
<BR> <FONT SIZE=2 FACE="Arial">Thank you</FONT>
</P>
<P> <FONT SIZE=2 FACE="Arial">Nicolas Simon</FONT>
</P>
</BODY>
</HTML>