Bug report #6993
Saving MS SQL Layer to shapefile fails with dates/datetime
| 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 about 11 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 almost 10 years ago
- Resolution set to fixed/implemented
#3
Updated by Nyall Dawson about 8 years ago
- Status changed from Open to Closed