Of course that won't work in this case as DBF does not support Date-time in a single field.
Back to the original question, if I'm understanding you are importing 2+ tables and joins between those tables aren't working when you try to join by Date-Time? If you really want things to work in SQLite use unixepoch to match the join. Are you using the QGIS join tool for this? I would write a view in sqlite/spatialite that joins the tables. It sounds like your issue stems from how QGIS read the spatialite tables and tries the join. If you do it with SQL then you can more finely control how the matches work (like the above mentioned epoch conversion can be done on the fly). PS: ogr2ogr should be able to batch convert your db consistently. Thanks, Alex On 05/24/2015 09:09 AM, Bernd Vogelgesang wrote: > Haven't worked with spatialite for a while, but by that time I needed to > work with DB Manager, QSpatialite and the Spatialite GUI to get things > done. Variety is nice, but having to use 3 tools is a bit too much imho. > > Actually I would have like to move all my work to spatialite, but as > qgis still seems to be very shape-o-centric (and postis is no option) > and it's hard to remember what syntax to use in this tool and which > function was in that, but not in the other, or the other way round, led > me on the path of lowest resistance: using shape files :( > > No offence, just a pitiful remark ;) > > Cheers > Bernd > > Am 24.05.2015, 17:13 Uhr, schrieb Paolo Cavallini <[email protected]>: > >> Il 24/05/2015 17:03, James Wood ha scritto: >> >>> I was afraid >> >> No problem with that, James - I just want to understand the real needs >> of users. My underlying idea is that variety is good, but too much >> duplication scares users away, so we're trying to reduce it when >> appropriate and feasible (remember the good old days where everything in >> QGIS was double? labelling, styling, etc.). >> All the best, and thanks for the feedback. >> > > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
