https://bugs.documentfoundation.org/show_bug.cgi?id=91353
Bug ID: 91353
Summary: Embedded Firebird – something wrong with the Table
field type Date or displaying it
Product: LibreOffice
Version: 5.0.0.0.alpha0+ Master
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 115692
--> https://bugs.documentfoundation.org/attachment.cgi?id=115692&action=edit
screen shot
It seems for me that the Month December "is forgotten", the January only have
28 Days or 29 in leap years like normally only February has.
Please take a look at the attached screen shot or the attached Database.
If you open the attached Database,
- go to tables
- open table "datum" by double-click
- manually change the first row "Datum" to 31.12.2014 where ID = 0
- leave the row
-> date switch to 31.01.2015
This goes back until 01.12.2014 switches to 01.01.2015. If you insert
30.11.2014 the displayed Date stays.
- manually insert into "Datum" 29.01.2015
- leave the row
-> date switch to 01.02.2015
- insert into “Datum” 29.12.2014
- leave the row
-> date switch to 29.01.2015
Do it until 31.01.2015, the date always switch to the begin of February. After
January seems to be OK. If you work with the date-function like DATEADD it is
the same behavior of the date.
If I use the following SQL Statement in Tools/SQL...
UPDATE "datum" SET "Datum" = '2014-12-31' WHERE "ID" = 0
and make a select
"Datum" from "datum" WHERE "ID" = 0
the output returns 0114-11-31
I use Win 8.1 and attached the Base file
--
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
