Bug 95705 - Storing of date anomaly
Summary: Storing of date anomaly
Status: RESOLVED DUPLICATE of bug 95412
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-11-09 14:29 UTC by Jonathan Camilleri
Modified: 2015-11-30 09:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
database (odb) (60.09 KB, application/vnd.sun.xml.base)
2015-11-09 14:29 UTC, Jonathan Camilleri 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Camilleri 2015-11-09 14:29:32 UTC 
Created attachment 120414 [details]
database (odb)

Dates cannot always be stored within the attached database.
I also checked the Control Panel > Regional settings of my operating system, which is Windows 2007 Server, but could not find an indication that the date format is inherited from the operating system, so LibreOffice base appears to have a logic of its own on date format.

As an example to highlight this concern, that I am not sure has been reported, see the PEP table and see the LastUpdated field on row 62/63.
Even though the format has been edited, the table still shows the date in short date format i.e. dd/mm/yy.  

See the following
1. https://en.wikipedia.org/wiki/Year_2000_problem
2. https://en.wikipedia.org/wiki/Year_2038_problem
Comment 1 Alex Thurgood 2015-11-09 16:01:16 UTC 
@Jonathan : The lastupdated field of PEP has a default US locale in the table view mode. If I change this to FR (my working language), the date format gets converted accordingly to the long date ISO format for France, dd/mm/yyy. If I then save the database again, quit LO, restart it and reload the ODB file, the date format of the lastupdated field is still in FR ISO long format.

My tests were done on OSX 10.11.1 with LO 5022.

Which version of LibreOffice locale are you using ? Are you using any lanugage packs ?
Comment 2 Robert Großkopf 2015-11-28 20:58:04 UTC 
Isn't this the same as  Bug 95412?
Seems the field is wrong formatted.
Comment 3 Alex Thurgood 2015-11-30 09:13:34 UTC 
(In reply to robert from comment #2)
> Isn't this the same as  Bug 95412?
> Seems the field is wrong formatted.

Agreed

*** This bug has been marked as a duplicate of bug 95412 ***