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

[Anita Graser]

I've opened a ticket for this issue:
https://github.com/qgis/QGIS/issues/30288

Regards,
Anita



On Sun, Jun 9, 2019 at 11:10 PM Anita Graser <anitagraser at gmx.at> wrote:

> 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/20190620/371f2c77/attachment.html>