[Qgis-developer] Problem inserting dates in Oracle

[Paolo Cavallini]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all.
I have been pointed out to a problem in inserting dates in Oracle. How does one
specify which format does the data have? Is it a parameter to be set at connection,
or server side?

The error is:

    SQL: ORA-01843: not a valid month
    Impossibile eseguire l'istruzione
    Errore: INSERT INTO
"QGIS_TEST"."ZONA_RECUPERO"("SHAPE","VINCSIDE","VINCSCODTI","CODTIPCART","VINSSUPERF","LEGIDESTAR","VINCSDATAI","VINCSDATAF","LEGIDESTOP","GEOLINK")
VALUES (:f,'23005869',NULL,NULL,NULL,NULL,'14/04/2014','31/12/2999',NULL,NULL) "

If we use to_date('2007/05/31','YYYY/MM/DD') instead, the INSERT goes well.

All the best, and thanks a lot.
- -- 
Paolo Cavallini - www.faunalia.eu
Corsi QGIS e PostGIS: http://www.faunalia.eu/training.html
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlLqPI0ACgkQ/NedwLUzIr4BZACgiTQX02RosUZ0mE4/sMMkopBY
4wEAoIqSUN1nVr3Fak5GVfLs5jxDGKK+
=XKoH
-----END PGP SIGNATURE-----