<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Matthias,<div class=""><br class=""></div><div class="">thank you for the hint, it works very well.</div><div class=""><br class=""></div><div class="">Sincerely,</div><div class="">Christoph<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">Am 22.05.2019 um 08:51 schrieb Matthias Kuhn <<a href="mailto:matthias@opengis.ch" class="">matthias@opengis.ch</a>>:</div><br class="Apple-interchange-newline"><div class="">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" class="">
<div text="#000000" bgcolor="#FFFFFF" class=""><p class="">Hi Christoph,</p><p class="">On export you can also choose in the field export options to use
the display string (Check "Replace with displayed value" for this
field).<br class="">
</p><p class="">In the layer properties -> attributes form of your layer it's
possible to define how QGIS will display and format your date, you
might possibly want to tune something in there too.<br class="">
</p><p class="">I hope that helps</p><p class="">Matthias<br class="">
</p>
<div class="moz-cite-prefix">On 5/22/19 8:45 AM, Christoph Jung
wrote:<br class="">
</div>
<blockquote type="cite" cite="mid:43F1B1A0-1564-4F99-B996-C9828E50D346@gmail.com" class="">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" class="">
Hello everyone,
<div class=""><br class="">
</div>
<div class="">I am a bit confused about dates/timestamps in QGIS.
I created a column in PostGIS to store timestamps in iso8601
format. If I load the table into QGIS and open the attribute
table, the timestamp will be shown like in pgAdmin:</div>
<div class=""><br class="">
</div>
<div class=""><span id="cid:part1.634C5908.EC06BBAB@opengis.ch"><Bildschirmfoto 2019-05-21 um 18.40.18.png></span></div>
<div class=""> Thats all fine. But when I export the table into
GeoJSON (right click on the layer - export), the format of the
timestamp changes a bit:</div>
<div class=""><span id="cid:part2.DA776DB4.006B8194@opengis.ch"><Bildschirmfoto 2019-05-21 um 18.40.37.png></span></div>
<div class="">I know that iso8601 offers different writings of the
timestamps and both should follow iso8601. But nonetheless the
characters are differing. Is it a general „problem“, did anybody
noticed it before?</div>
<div class=""><br class="">
</div>
<div class="">Sincerely,</div>
<div class="">Christoph</div>
<br class="">
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
</div>
_______________________________________________<br class="">Qgis-user mailing list<br class=""><a href="mailto:Qgis-user@lists.osgeo.org" class="">Qgis-user@lists.osgeo.org</a><br class="">List info: https://lists.osgeo.org/mailman/listinfo/qgis-user<br class="">Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user</div></blockquote></div><br class=""></div></body></html>