https://bugzilla.novell.com/show_bug.cgi?id=866623 https://bugzilla.novell.com/show_bug.cgi?id=866623#c0 Summary: Libreoffice Base shows some MySQL datetime values off by one minute Classification: openSUSE Product: openSUSE 13.1 Version: Final Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: LibreOffice AssignedTo: bnc-team-ooo@forge.provo.novell.com ReportedBy: dennisgrunert@hotmail.de QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:27.0) Gecko/20100101 Firefox/27.0 System: openSUSE 13.1 Libreoffice 4.1.4.2-13.1 from the openSUSE 13.1 update repository libreoffice-base-drivers-mysql 4.1.4.2-13.1 from the same repo (or use JDBC) Reproducible: Always Steps to Reproduce: 1. Install the libreoffice-base-drivers-mysql package or use JDBC. 2. Create a mysql database with a datetime column and connect to it with Libreoffice. 3. Make a data entry with a datetime value of "03.03.2014 22:00". Actual Results: The datetime will be safed as "03.03.2014 21:59" instead. If you do the same with 22:01, you will get 22:00 instead. This only happens for some times depending on the date. Expected Results: The datetime should be safed as entered. This is a problem with saving the data, not displaying it since it will also be shown wrong when I look at the database with other programs once it was entered with LO. This happens with the MySQL Connector and JDBC. This did _not_ happen with Libreoffice 4.0 and the connector which was deliviered with it. This bug does _not_ happen with the Windows version of LO 4.1.5 and the MySQL Connector 1.0.2 (not yet published but available here: https://dl.dropboxusercontent.com/u/193133/mysql-connector-ooo.oxt) As far as I know Libreoffice changed the API for datetime values in 4.1. Since this bug is linux (or openSUSE?) only, I posted it here. Maybe it is also a MySQL/MariaDB problem (the database is hosted on an Ubuntu 12.04.4 LTS server with MySQL 5.5.35)? -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.