id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc 4667,Dates are set to 30/12/1899 when creating a ShapeFile from PostGIS via CopyLayer,PaulFMichell,warmerdam,"We call OGR_DS_CopyLayer in gdal19.dll (16/5/2012 SVN) to copy tables from a PostGIS 1.5 database to ESRI shapefiles. All of the date values are set to 30/12/1899. We can replicate the issue with the following code: procedure TMyApplication.DoRun; var InputOGRDataSource: TOGRDataSource; OutputOGRDriver: TOGRSFDriver; OutputOGRDataSource: TOGRDataSource; OutputOptions: Array [0..1] Of PChar; OGRLayer: TOGRLayer; OutputFolder: String; begin OGRRegisterAll; InputOGRDataSource := OGROpen(PChar('PG:dbname=''HCA'' host=''TEPData'' port=''5432'' user=''user'' password=''password'''), 0, Nil); If InputOGRDataSource<>Nil Then Begin OGRLayer := OGR_DS_ExecuteSQL(InputOGRDataSource, PChar('SELECT * FROM ""SiteAccess"".""NewSigns"";'), Nil, Nil); OutputOGRDriver := OGRGetDriverByName(PChar('ESRI Shapefile')); OutputOptions[0] := Nil; OutputOptions[1] := Nil; OutputFolder := ExcludeTrailingPathDelimiter(ExtractFilePath(ParamStr(0))); OutputOGRDataSource := OGR_Dr_CreateDataSource(OutputOGRDriver, PChar(OutputFolder), OutputOptions); OGR_DS_CopyLayer(OutputOGRDataSource, OGRLayer, PChar('Test'), OutputOptions); End; OGR_DS_ReleaseResultSet(InputOGRDataSource, OGRLayer); OGR_DS_Destroy(InputOGRDataSource); OGR_DS_Destroy(OutputOGRDataSource); OGRCleanupAll; end; ",defect,closed,normal,1.9.2,OGR_SF,svn-trunk,normal,fixed,CopyLayer 1899 ESRI Shapefile,