SPIT converts null dates to invalid values

[qgib]

Author Name: Aren Cambre (Aren Cambre)
Original Redmine Issue: 3335

Redmine category:c++_plugins
Assignee: Tim Sutton

---

If I have a shapefile with a DBF that has null values in the date column, SPIT translates these null dates to an invalid 0000/00/00 value. For example, this error:

Problem inserting features from file:
C:/[redacted]/TxDOT_Roadways.shp
The database gave an error while executing this SQL:
INSERT INTO "public"."TxDOT_Roadways"("OBJECTID","STRATMAP_I","RTE_NM",... (rest of SQL trimmed)
The error was:
ERROR:  date/time field value out of range: "0000/00/00"
LINE 1: ...0','058AA0353','AA','353',NULL,'353','2010/12/01','0000/00/0...

If I use shp2pgsql.exe instead, the date gets translated to NULL in the INSERT INTO statements.

If you want to reproduce, download TxDOT Roadways 2010 at http://www.tnris.state.tx.us/datadownload/download.jsp and import TxDOT_Roadways.shp.

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

IMHO SPIT will not be maintained, as DB Manager will enter into Master. No work should go into fixing this.

---

• pull_request_patch_supplied was configured as 0
• resolution was configured as wontfix
• status_id was changed from Open to Closed