Issue 123949

Summary: Fractions of a second missing in Time Field
Product: Base Reporter: charlie <casalva48>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: issues, qualkenqa
Version: 4.0.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0
Developer Difficulty: ---

Description charlie 2014-01-02 16:24:48 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'.
Comment 1 Qualken 2014-08-19 06:54:21 UTC
Hi charlie,

  i have verified your issue, i too got the same problem while choosing italian (italy) in 4.1.0 version
Comment 2 mroe 2014-08-19 10:57:10 UTC
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