[Libreoffice-bugs] [Bug 132824] New: EDITING: Embedded Firebird - SQL select statements that require dates to be converted to strings produce incorrect results for dates earlier than 15 OCT 1582

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: paul.ward at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200507/3f2b8e0f/attachment-0001.htm>