https://bugs.documentfoundation.org/show_bug.cgi?id=132824
Julien Nabet <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|EDITING: Embedded Firebird |EDITING: SQL select |- SQL select statements |statements that require |that require dates to be |dates to be converted to |converted to strings |strings produce incorrect |produce incorrect results |results for dates earlier |for dates earlier than 15 |than 15 OCT 1582 |OCT 1582 | Blocks| |116968 CC| |[email protected] --- Comment #3 from Julien Nabet <[email protected]> --- In HSQLDb, I can't enter a date before 15/10/1582 in the table. 04/10/1582 is automatically converted into 24/10/1582, I suppose HSQLDB bug (at least with the old version we use). I tried with MariaDB, I confirm what Robert indicated, SQL and GUI behave differently, in GUI 04/10/1582 stays 04/10/1582, on SQL query, it changes to 14/10/1582 so not specific to embedded Firebird Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] [META] Migrating existing embedded HSQLDB databases to Firebird -- You are receiving this mail because: You are the assignee for the bug.
