OGR2OGR SQL to Shapefile issue with Date columns

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
Report Content as Inappropriate

OGR2OGR SQL to Shapefile issue with Date columns

This post has NOT been accepted by the mailing list yet.
I have been trying to use ogr2ogr to export a table from SQL Server to a shape file. The process works fine, however, any columns in the database table of type Date are being exported as type String(10) to the shape file. I need to retain the datatype.
The same process against a PostGres database works as expected and the Date columns are exported to the Shapefile as a Date.

Is there an error in the MSSQL drivers for ogr2ogr or are there switches I can use to stop this behaviour?

Any info will be greatly appreciated.