Bug report #6993

Saving MS SQL Layer to shapefile fails with dates/datetime

Added by Nathan Woodrow almost 8 years ago. Updated almost 5 years ago.

Status:Closed
Priority:Normal
Assignee:Tamas Szekeres
Category:Data Provider/MSSQL
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed/implemented
Crashes QGIS or corrupts data:No Copied to github as #:16097

Description

If you try and save a MS SQL layer with date or datetime column types you get an error while saving

Export to vector file failed.
Error: Feature write errors:
Invalid variant type for field DateInstalled[8]: received QDateTime with type 1945-01-01T00:00:00
Invalid variant type for field DateInstalled[8]: received QDateTime with type 1945-01-01T00:00:00
...

Saving a PostGIS/Spatialite layer with dates or datetime doesn't have this issue.

History

#1 Updated by Tamas Szekeres over 7 years ago

Could you check whether the recent fix for #7249 could also solve this problem? I've tried with date type and it appears to be ok.

#2 Updated by Nathan Woodrow over 6 years ago

  • Resolution set to fixed/implemented

#3 Updated by Nyall Dawson almost 5 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF