Bug 71007 - EDITING: Embedded Firebird - Impossible to set milliseconds in a timefield with GUI
Summary: EDITING: Embedded Firebird - Impossible to set milliseconds in a timefield wi...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: 4.2.0.0.alpha0+ Master
Hardware: x86-64 (AMD64) Linux (All)
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-10-29 16:29 UTC by robert
Modified: 2015-01-03 17:41 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Start with LO 4.2 only - try to input time with milliseconds. Works only in direct SQL. (49.91 KB, application/vnd.oasis.opendocument.base)
2013-10-29 16:29 UTC, robert
Details

Description robert 2013-10-29 16:29:01 UTC
Created attachment 88306 [details]
Start with LO 4.2 only - try to input time with milliseconds. Works only in direct SQL.

Create an embedded Firebird-Database (see attachment).
Create a table with primary-key and a field of the type "TIME".
Format this field with the formatcode [HH]:MM:SS.0000 (Language English(USA)).
Try to put the following value in the TIME-field:
13:24:35.1234
After saving it is shown as
13:24:35.0000
Seems the milliseconds have been gone.
Same behavior when trying this with a form connected to this table.

Try the query of the attachment. There are two fields. One field shows the value of "Time" as time, the second field shows it, as it must be reformatted for showing the milliseconds in Firebird (CAST("Time" AS VARCHAR(13))).
The milliseconds had been gone.

Try the following in Tools → SQL:
UPDATE "Table_Time" SET "Time" = '12:24:56.1234' WHERE "ID" = 1;
(only if there is a field "ID2 with the value '1')
Refresh the query. The query will show the milliseconds in this fields.

This shows: 
Firebird is able to save the milliseconds.
The GUI isn't able to send the right values to Firebird.
The GUI isn't able to fetch the values from Firebird in a time-field or a formatted field.
Comment 1 Julien Nabet 2013-10-29 23:35:51 UTC
Comment on attachment 88306 [details]
Start with LO 4.2 only - try to input time with milliseconds. Works only in direct SQL.

Mimetype fixed
Comment 2 Alex Thurgood 2015-01-03 17:41:04 UTC
Adding self to CC if not already on


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.