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