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

          Priority: medium
            Bug ID: 75853
          Assignee: [email protected]
           Summary: EDITING: Wrong timestamp in a table with date and time
                    (except 00:00:00) before 1899-12-30
          Severity: normal
    Classification: Unclassified
                OS: Linux (All)
          Reporter: [email protected]
          Hardware: x86-64 (AMD64)
            Status: NEW
           Version: Inherited From OOo
         Component: Database
           Product: LibreOffice

Created attachment 95245
  --> https://bugs.freedesktop.org/attachment.cgi?id=95245&action=edit
Open the query and try to put 29.12.1899 10:00:00 in the timestampfield ...

Open the attached database.
Open the query. Shows a date and a timestamp-field.
Put a date in the the timestamp-field (like 29.12.1899).
Works right.
Pute a full timestamp in the timestamp-field (like 29.12.1899 01:00:00)
Fails. The timestamp is saved as 30.12.1899 23:59:59.

Could be this is a special bug of HSQLDB. When I try the same with internal
firebird I get other errors with all values before 1.1.1900 together with a
time ...

I have tested it with many versions. It first appears in LO 3.3.0_Beta1 here.
So I set the first version to "Inherited ..."
My System: OpenSUSE 12.3 64bit rpm Linux

-- 
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

Reply via email to