[Qgis-user] Export from csv layer to geopackage changes date and time attributes to string

[Totò Fiandaca]

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.
The csvt file has only one line and contains the data type.

https://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/

saluti

Il giorno mer 20 nov 2024 alle ore 17:02 Reetz, Michael (NLPVW) via
QGIS-User <qgis-user at lists.osgeo.org> ha scritto:

> Dear all,
>
>
>
> 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?
>
>
>
> Best regards
>
> Michael
>
>
>
>
>
>
>
> *****************************************
>
> Michael Reetz
>
> Datenbanken und Anwendungsentwicklung
> Nationalpark-Verwaltung Niedersächsisches Wattenmeer
> Virchowstr. 1 | 26382 Wilhelmshaven
> Tel.: +49 (0) 4421 911 291
> e-mail: michael.reetz at nlpvw.niedersachsen.de
> <michael.reetz at nlpv-wattenmeer.niedersachsen.de>
> Web: https://www.*nationalpark-wattenmeer.de
> <http://nationalpark-wattenmeer.de>*
>
>
>
>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>


-- 
*Ing. Salvatore Fiandaca*
*mobile*.:+39 327.493.8955
*m*: *pigrecoinfinito at gmail.com <pigrecoinfinito at gmail.com>*
*C.F*.: FNDSVT71E29Z103G
*P.IVA*: 06597870820
*membro QGIS Italia - http://qgis.it/ <http://qgis.it/>*
*socio GFOSS.it - *http://gfoss.it/
*member OSGeo* - *https://www.osgeo.org/member/fiandaca/*
<https://www.osgeo.org/member/fiandaca/>
*blog:*
* https://pigrecoinfinito.com/ <https://pigrecoinfinito.com/> FB: Co-admin
- https://www.facebook.com/qgis.it/ <https://www.facebook.com/qgis.it/>**
<https://www.facebook.com/qgis.it/> *
*TW:  <http://goog_95411464>**https://twitter.com/totofiandaca
<https://twitter.com/totofiandaca>*

37°35'11.4"N 14°10'25.1"E - EPSG:4326

“Se la conoscenza deve essere aperta a tutti,
perchè mai limitarne l’accesso?”
R. Stallman

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 FIANDACA SALVATORE. Qualora fosse stato ricevuto per errore si prega di
informare tempestivamente il mittente e distruggere la copia in proprio
possesso.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20241120/bef56a14/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 6513 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20241120/bef56a14/attachment-0001.png>