<div dir="ltr"><div class="gmail_default" style="font-family:garamond,serif;font-size:large">Try to create the auxiliary file of the csv file, that is, the file with the same name as the csv file, but with the extension csvt.<br>The csvt file has only one line and contains the data type.<br><br><a href="https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/">https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/</a></div><div class="gmail_default" style="font-family:garamond,serif;font-size:large"><br></div><div class="gmail_default" style="font-family:garamond,serif;font-size:large">saluti</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mer 20 nov 2024 alle ore 17:02 Reetz, Michael (NLPVW) via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-8012868666876232846">
<div lang="DE" style="overflow-wrap: break-word;">
<div class="m_-749140457519929684WordSection1">
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif">Dear all,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:Tahoma,sans-serif">I have added a csv file as layer to my project. Date and time columns are identified correctly. Now I’m trying to export the layer into a geopackage. The date and time attributes
are all changed into strings although date and datetime are possible in a geopackage (as far as I know). Any idea why this happens and how to work around this?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif">Best regards<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif">Michael<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:Tahoma,sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:9pt;font-family:Tahoma,sans-serif">*****************************************
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9pt;font-family:Tahoma,sans-serif">Michael Reetz<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9pt;font-family:Tahoma,sans-serif">Datenbanken und Anwendungsentwicklung<br>
Nationalpark-Verwaltung Niedersächsisches Wattenmeer <br>
Virchowstr. 1 | 26382 Wilhelmshaven <br>
Tel.: +49 (0) 4421 911 291 <br>
e-mail: <a href="mailto:michael.reetz@nlpv-wattenmeer.niedersachsen.de" target="_blank"><span style="color:blue">michael.reetz@nlpvw.niedersachsen.de</span></a>
<br>
Web: <a href="https://www./" target="_blank"><span style="color:blue">https://www.</span></a><u><span style="color:blue"><a href="http://nationalpark-wattenmeer.de" target="_blank">nationalpark-wattenmeer.de</a></span></u>
<u></u><u></u></span></p>
<p class="MsoNormal"><span><img border="0" width="219" height="118" style="width: 2.2812in; height: 1.2291in;" id="m_-749140457519929684Grafik_x0020_1" src="cid:ii_1934a5da878692e331"><u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
_______________________________________________<br>
QGIS-User mailing list<br>
<a href="mailto:QGIS-User@lists.osgeo.org" target="_blank">QGIS-User@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</div></blockquote></div><div><br clear="all"></div><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><font size="2"><font face="garamond, serif"><b>Ing. Salvatore Fiandaca</b><br><b>mobile</b>.:+39 327.493.8955 <br><b>m</b>: <b><a href="mailto:pigrecoinfinito@gmail.com" target="_blank">pig<span></span><span></span>recoinfinito@gmail.com</a></b></font></font></div><div><font face="garamond, serif" size="2"><b>C.F</b>.: FNDSVT71E29Z103G</font></div><div><font face="garamond, serif" size="2"><b>P.IVA</b>: 06597870820</font></div><div><font face="garamond, serif" size="2"><b>membro QGIS Italia - <a href="http://qgis.it/" target="_blank">http://qgis.it/</a></b><br><b>socio GFOSS.it - </b><a href="http://gfoss.it/" style="font-weight:bold" target="_blank">http://gfoss.it/</a></font></div><div><b>member OSGeo</b> - <a href="https://www.osgeo.org/member/fiandaca/" target="_blank"><b>https://www.osgeo.org/member/fiandaca/</b></a></div><div><font face="garamond, serif" size="2"><b>blog:</b><b><a href="https://pigrecoinfinito.com/" target="_blank"> https://pigrecoinfinito.com/</a> <br>FB: Co-admin - <a href="https://www.facebook.com/qgis.it/" target="_blank">https://www.facebook.com/qgis.it/</a></b></font><b style="font-family:garamond,serif;font-size:small"><a href="https://www.facebook.com/qgis.it/" target="_blank"> </a> </b></div><div><b style="font-family:garamond,serif;font-size:small">TW:<a href="http://goog_95411464" target="_blank"> </a></b><font face="garamond, serif" size="2"><b><a href="https://twitter.com/totofiandaca" target="_blank">https://twitter.com/totofiandaca</a></b></font></div><div><font face="garamond, serif" size="2"><br></font></div><div dir="ltr"><font face="garamond, serif">37°35'11.4"N 14°10'25.1"E<font size="2"> - EPSG:4326</font></font></div><div dir="ltr"><font face="garamond, serif"><font size="2"><br></font></font></div><div dir="ltr"><font face="garamond, serif"><font size="2">“Se la conoscenza deve essere aperta a tutti,</font></font></div><div dir="ltr"><font face="garamond, serif"><font size="2">perchè mai limitarne l’accesso?” </font></font></div><div dir="ltr"><font face="garamond, serif"><font size="2">R. Stallman<br><br></font></font><span style="font-family:"Trebuchet MS";font-size:10px">Questo documento, allegati inclusi, contiene informazioni di proprietà di FIANDACA SALVATORE e deve essere utilizzato esclusivamente dal destinatario in relazione alle finalità per le quali è stato ricevuto. E' vietata qualsiasi forma di riproduzione o divulgazione senza l'esplicito consenso di </span><span style="font-family:"Trebuchet MS";font-size:10px">FIANDACA SALVATORE</span><span style="font-family:"Trebuchet MS";font-size:10px">.</span><span style="font-family:"Trebuchet MS";font-size:10px"> Qualora fosse stato ricevuto per errore si prega di informare tempestivamente il mittente e distruggere la copia in proprio possesso.<br></span><font face="garamond, serif"><font size="2"><br><br><br></font></font></div><div dir="ltr"><font face="garamond, serif"><font size="2"></font></font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>