[QGIS-Developer] SpatiaLite and GeoPackage provider changes format of datetime strings

[Anita Graser]

Hi,

I have a SpatiaLite (
https://www.dropbox.com/s/4dtkpmlyhs741bn/geolife-beijing.sqlite?dl=0) with
string fields that contain timestamps in %Y-%m-%d %H:%M:%S format. However,
if I access the min or max values through the provider, the format changes
to  %Y/%m/%d %H:%M:%S

p = l.dataProvider()
p.minimumValue(2)
'2008/11/11 00:38:00'


This messed up TimeManager
https://github.com/anitagraser/TimeManager/issues/218

Would you consider that a bug? Should I open a ticket?

Regards,
Anita
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190609/053deee6/attachment.html>