Apache OpenOffice (AOO) Bugzilla – Issue 123949
Fractions of a second missing in Time Field
Last modified: 2014-08-19 10:57:10 UTC
I have a table with a field formatted TIME HH.MM.SS,00 in local Italian. If, for example, I enter 12.34.56,78 data is saved 12.34.56,00. ',78' becomes '00'.
Hi charlie, i have verified your issue, i too got the same problem while choosing italian (italy) in 4.1.0 version
Can confirm the behaviour. Tested with internal HSQLDB. Example for table "table1" with at least 2 columns "id" (Integer <AutoValue>) and "tine" (Time), using Tools → SQL…: UPDATE "table1" SET "time" = CURRENT_TIME WHERE "id" = 0