<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Christoph,</p>
<p>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>
</p>
<p>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>
</p>
<p>I hope that helps</p>
<p>Matthias<br>
</p>
<div class="moz-cite-prefix">On 5/22/19 8:45 AM, Christoph Jung
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:43F1B1A0-1564-4F99-B996-C9828E50D346@gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
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=""><img apple-inline="yes"
id="B6D110DB-C1BA-49FA-B40A-DDB1A4E5CE34"
src="cid:part1.634C5908.EC06BBAB@opengis.ch" class=""></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=""><img apple-inline="yes"
id="5BD2A98F-5B0C-4E30-BEF2-D344CC36EE16"
src="cid:part2.DA776DB4.006B8194@opengis.ch" class=""></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>
<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>
</body>
</html>