On 15 July 2010 15:25, Andrea Zagli <[email protected]> wrote: > Il giorno mer 14 lug 2010 13:59:47 CEST, Vivien Malerba ha scritto: >> >> [...] >>> >>> - i don't know if so for every database, but when the field is of type >>> date >>> (or time or timestamp) and it is null postgresql wants in csv file a >>> zero-lenght string; so i prepared another patch (in attach named >>> null_date.patch) (it makes use of the two functions that i send 2 days >>> ago) >> >> I've added a "NULL_AS_EMPTY" export option rather than applying your >> patch which would have changed the way Libgda currently works (which >> is bad for already installed applications), see >> >> http://git.gnome.org/browse/libgda/commit/?id=5ccd3eb2c24fea2caad3c9bcc1640d578194f6de > > thanks, but... > > i don't know how it was possible, but i have an msaccess db with date fields > with invalid data inside, and without checking date/time/timestamp validity > when i export the table with gda-browser i obtain a csv with invalid data > > for example i get values like "1987-00-00 00.00.00+0" > > can libgda validate the field value inside gda_value_stringify?
I see... I'll add another option to discard invalid values in date formats when exporting data. I'll do this ASAP. Regards, Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
