<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div class="gmail_default" style="font-size:small">Hi,<br></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default">I have a SpatiaLite (<a href="https://www.dropbox.com/s/4dtkpmlyhs741bn/geolife-beijing.sqlite?dl=0">https://www.dropbox.com/s/4dtkpmlyhs741bn/geolife-beijing.sqlite?dl=0</a>) 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 </div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default"><pre style="font-size:11.9px;box-sizing:border-box;font-family:SFMono-Regular,Consolas,"Liberation Mono",Menlo,Courier,monospace;margin-bottom:0px;margin-top:0px;background-color:rgb(246,248,250);border-radius:3px;line-height:1.45;overflow:auto;padding:16px;word-break:normal;color:rgb(36,41,46)">p = l.dataProvider()
p.minimumValue(<span class="gmail-pl-c1" style="box-sizing:border-box;color:rgb(0,92,197)">2</span>)
'<span class="gmail-pl-c1" style="box-sizing:border-box;color:rgb(0,92,197)">2008</span>/<span class="gmail-pl-c1" style="box-sizing:border-box;color:rgb(0,92,197)">11</span>/<span class="gmail-pl-c1" style="box-sizing:border-box;color:rgb(0,92,197)">11</span> <span class="gmail-pl-c1" style="box-sizing:border-box;color:rgb(0,92,197)">00</span>:<span class="gmail-pl-c1" style="box-sizing:border-box;color:rgb(0,92,197)">38</span>:<span class="gmail-pl-c1" style="box-sizing:border-box;color:rgb(0,92,197)">00</span>'</pre><div class="gmail_default"><br></div>This messed up TimeManager <a href="https://github.com/anitagraser/TimeManager/issues/218">https://github.com/anitagraser/TimeManager/issues/218</a></div><div class="gmail_default"><br></div><div class="gmail_default">Would you consider that a bug? Should I open a ticket? </div><div class="gmail_default"><br></div><div class="gmail_default">Regards,</div><div class="gmail_default">Anita</div><div class="gmail_default"><br></div></div></div></div></div></div></div>