https://bugs.documentfoundation.org/show_bug.cgi?id=132824
Bug ID: 132824
Summary: EDITING: Embedded Firebird - SQL select statements
that require dates to be converted to strings produce
incorrect results for dates earlier than 15 OCT 1582
Product: LibreOffice
Version: 6.4.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: paul.w...@gmx.com
Description:
Create a table with a column of dates. Enter 15 Oct 1582 and 4 Oct 1582.
Execute SQL command "Select * from table". Output will be correct for the first
date, but 14 Oct 1582 for second.
Steps to Reproduce:
1.Create a table with a column of dates.
2.Enter 15 Oct 1582 and 4 Oct 1582.
3.Execute SQL command "Select * from table".
Actual Results:
15 Oct 1582
14 Oct 1582
Expected Results:
15 Oct 1582
4 Oct 1582
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.3.2 (x64)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
--
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