https://bugs.freedesktop.org/show_bug.cgi?id=59200
--- Comment #5 from Alex Thurgood <[email protected]> --- (In reply to comment #4) > In MySQL, "0000-00-00 00:00:00" is not a NULL value, but a zero timestamp. > NULL and "0000-00-00 00:00:00" are distinct values. "0000-00-00 00:00:00" is > a MySQL-specific idiosyncrasy, an "anomalous" value which does *not* conform > to (from memory) the SQL standard, nor ODBC: > Yes, I've always had misgivings about the way MySQL considered invalid dates... > The MySQL ODBC Connector (the driver provided by MySQL) has an option > "convert zero date/timestamp to NULL" so as not to leak these anomalous > values to ODBC applications; if the column is "NOT NULL", then it may > confuse applications in other ways :-| I haven't tested how LibreOffice > reacts to this (NULL in a non-NULLable column). > I will have a look to see if the Actual Technologies has such a parameter somewhere. Alex -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
