[gdal-dev] Problem with using ogr2ogr to migrate data from Postgis to TSQL/Oracle Spatial

Bo Victor Thomsen bo.victor.thomsen at gmail.com
Sun Oct 25 02:19:45 PDT 2015


Have you tried typecasting your "timestamp with time zone" to a 
"timestamp witout time zone" as a workaround ?

*ogr2ogr ... -sql "select id, date_modified::timestamp, geom from 
public.my_geometry_table" ...*


Regards

Bo Victor Thomsen
AestasGIS
Denmark

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20151025/30718f51/attachment.html>


More information about the gdal-dev mailing list