I created a new embedded Firebird-database. I defined in this database a table with a field ‘DATE1’ in it. Now I want to add data to this table. Double click on this table name, I fill in a date in this field like 10/05/19, the system changes that to 05/10/19. What is going on with Firebird embed? With HSQL in the past (older versions of LibreOffice), a date like 10/05/19 stays 10/05/19. In Belgium and France we note dates as DD/MM/YY.
This swapping happens only when Day<=12. For example 13/05/19 stays 13/05/19, but 12/05/19 becomes 05/12/19. Very strange.
My local settings Options/Language Settings are:
-User Interface: Default - English (USA)
-Locate setting: Dutch(Belgium)
-Date acceptance patters: D/M/Y
Libreoffice v 6.1.5.2 on Windows 10 and Firebird-database created and embedded in Base.
What can I do that 10/05/19 stays 10/05/19 (DD/MM/YY)?