[Libreoffice-bugs] [Bug 132824] EDITING: Embedded Firebird - SQL select statements that require dates to be converted to strings produce incorrect results for dates earlier than 15 OCT 1582
https://bugs.documentfoundation.org/show_bug.cgi?id=132824 Robert Großkopf changed: What|Removed |Added CC||rob...@familiegrosskopf.de Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #2 from Robert Großkopf --- The GUI will show the right results. But every date between 1582-10-04 and 1582-10-15 will be shown as 1899-12-30, because the Gregorian counting has been "corrected" 10 days. If you will input data through tools → SQL it will work as expected (without hiding any dates). Don't know why it should work different here … The different behavior between GUI and direct SQL is a bug. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132824] EDITING: Embedded Firebird - SQL select statements that require dates to be converted to strings produce incorrect results for dates earlier than 15 OCT 1582
https://bugs.documentfoundation.org/show_bug.cgi?id=132824 QA Administrators changed: What|Removed |Added Whiteboard| QA:needsComment| -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132824] EDITING: Embedded Firebird - SQL select statements that require dates to be converted to strings produce incorrect results for dates earlier than 15 OCT 1582
https://bugs.documentfoundation.org/show_bug.cgi?id=132824 --- Comment #1 from libre officer --- This is because "Thursday, 14 October 1582" is a proleptic date, which means it is a date that is calculated as a Gregorian date before the date of its adoption (Friday, 15 October 1582). The "Thursday, 4 October 1582" is in fact a Julian date not a Gregorian one. This needs to be further discussed. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132824] EDITING: Embedded Firebird - SQL select statements that require dates to be converted to strings produce incorrect results for dates earlier than 15 OCT 1582
https://bugs.documentfoundation.org/show_bug.cgi?id=132824 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs