Created attachment 83140 [details] Time (and Timestamp) in connections between MariaDB and Base - bugs since LO 4.1.* There seem to be some problems with date and time in the connection between MySQL/MariaDB and Base. This is the first for the time and the direct connection (connector: http://code.google.com/a/apache-extras.org/p/aoo-my-sdbc/) When I open a MariaDB-table with a time in LO up to 4.0.4.2 the time is shown, for example, as 20:13:16. Works with the direct connector and with JDBC. When I open the same table with LO 4.1.0.0.beta1 and all other 4.1-versions, LO shows with the direct connection 00:20:13 instead of 20:13:16. The connection with JDBC works right in this case.
Apache OpenOffice and LibreOffice have diverged as far as date&time datatypes are concerned. A connector compiled for Apache OpenOffice will not work with LibreOffice, especially in the date & time area. Reopen if you can reproduce with LibreOffice 4.1.0.4 or later, with a connector compiled for LibreOffice 4.1.0.4 (the release version, not an alpha/beta/rc).