Hi Larry,
The typeless nature of SQLite makes it perhaps impossible to treat the dates in
a perfect way. There is some background info in this thread
http://thread.gmane.org/gmane.comp.gis.gdal.devel/40172
Here follows a full test set-up. Start from an empty Spatialite DB and create
test data
Jukka, can you send me the exception stack you are seeing, or even better,
a small example SpatialLite DB file that contains the data causing the
error, along with an example of the query you are using that causes the
error?The SQLite and/or SpatiaLite JDBC drivers are responsible for
From the doc (https://www.sqlite.org/datatype3.html), sqlite datatype
system seems to be very different
from other databases.
A date may be stored as a String, a Integer or a Double, even if it is
declared as a date.
If it is stored as a String, I think that getTimestamp will not
recognize