https://bugs.freedesktop.org/show_bug.cgi?id=67186

          Priority: medium
            Bug ID: 67186
          Assignee: libreoffice-bugs@lists.freedesktop.org
           Summary: VIEWING REPORTBUILDER: TIMESTAMP incorrectly
                    displayed, (2 days behind)
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: ja...@jswhite.net
          Hardware: x86-64 (AMD64)
            Status: UNCONFIRMED
           Version: 4.0.3.3 release
         Component: Database
           Product: LibreOffice

This bug is only present in the 4.x.x branch. Works in 3.6.7

Using a MySQL database with either a TIMESTAMP or a DATESTAMP field. It
displays and behaves correctly in the Form editor. However in a REPORT,
attempting to display it results in a incorrect date. For instance if I update
a record on `7/22/13 2:25pm`, it will display the date of the timestamp 2 days
in the past so that it appears `7/20/13 2:25pm`. I have confirmed in my case
that the database contains the correct date and that in fact the REPORT
component is incorrectly displaying the date by 2 days.

The behavior has remained constant throughout the various hours of the day.

LibreOffice version: as you know Report Builder in the 4.0.4 Release crashes
Libre Office so I must use 4.0.3 (windows, portable)
Connection Type: JDBC, It is not the JDBC a fault. Libreoffice displays
TIMESTAMP correctly in forms

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to