Spatialite and Date Field

[qgib]

Author Name: Randal Hale (@rjhale1971)
Original Redmine Issue: 13928
Affected QGIS version: 2.12.0
Redmine category:data_provider/spatialite

---

Building a spatialite database and I can't create a date attribute from the new spatialite layer menu.

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

That's because SpatiaLite databases don't support date or time data types. See https://www.sqlite.org/datatype3.html

[qgib]

Author Name: Randal Hale (@rjhale1971)

---

Oh man....I stink. I thought there was a datetime data type that ...and I'm reading.....there isn't. I suck. I'm sorry for clogging up the list with bugs that aren't bugs.

---

• status_id was changed from Open to Closed

[qgib]

Author Name: Randal Hale (@rjhale1971)

---

Oh man....I stink. I thought there was a datetime data type that ...and I'm reading.....there isn't. I suck. I'm sorry for clogging up the list with bugs that aren't bugs.