Issue 123949 - Fractions of a second missing in Time Field
Summary: Fractions of a second missing in Time Field
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 4.0.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-01-02 16:24 UTC by charlie
Modified: 2014-08-19 10:57 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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